Fw: Ofbiz database interaction problem

[Chandresh Turakhia <ch...@bhartitelesoft.com>]

Dear all.

How wise would be makes changes in the 
\framework\entity\src\org\ofbiz\entity\ code to implement "Connect by " 
clause .
Thinking of adding "parent" and "child" relation defined separetly in xsd 
and the generator writes CONNECT by clause

Nice if some one can point me if similiar stuff can be achieve by modelling 
using extensibility pattern. I think it should.

Where can i find more elobrate info on extensibility pattern. Please be 
request to pardon my ignorance.

Any pointers.


> Hi Chand,
>
> We have successfully implemented queries involving joins,
> operations(+,-,*,/) and functions(max,min,avg) by making view entities in
> entitymodel.xml.
> But still we have not found any solutions to following as far as database
> interactions are concerned.
>
> 1.How to write queries containing 'CONNECT BY PRIOR'?, for example 
> consider
> following
>
> SELECT U.user_id, U.user_name
> FROM users U
> WHERE U.status = 'Y' AND  U.network_code = ? AND U.category_code = 'DIST'
> AND UPPER(U.user_name) LIKE UPPER('%Singh%')
> CONNECT BY PRIOR U.user_id=U.parent_id START WITH U.user_id= 'ABC0001'
> ORDER BY U.user_name
>
> 2. How to write sql DECODES?For example consider following
>
> SELECT u.user_id, u.user_name FROM users u  ,users pu
> WHERE u.network_code = ? AND u.status = 'Y'  AND u.category_code = ? AND
> u.user_id != ?
> AND pu.parent_id = DECODE(pu.parent_id,'ROOT',pu.parent_id,?)
> AND u.parent_id = DECODE(pu.parent_id,'ROOT',?,u.parent_id)
> ORDER BY u.user_name
>
>
> 3. How to implement LEAST function in view entities as in SQL?
>
> 4. How to implement inner/sub queries or achieve the similar behaviour?
>
>
> Actually we are implementing a process of Pretups in ofbiz framework and
> above queries(and similar) are being used at lot of places in code.
>
> If possible please guide us.
>
>