How to execute nested queries in OfBiz?

[rams-2]

Hi All,
Can any one suggest me how to execute nested queries and queries involving
complex joins using OfBiz entity engine?
Are we able to execute such queries?
Can submit a String query to the OfBiz engine so that I can get GenericEntity
List matching that query?
Thanks in advance.
Regards
RamReddy



This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient or received it in error, please contact the sender by reply e-mail and destroy all copies of the original message. Please do not copy it for any purpose or disclose its contents.

Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved

[Souvik Saha Bhowmik]

This can be implemented both from minilang as welll as java...
 For minilang use entitiy-condition
 it has a sub tag called condition-list. You can use as many
condition-list as u like. condition-list can be nested as well
 u need to specify AND or OR tindicate whether the conditions inside
should be ANDed or ORed.
The conditions should be mentioned in condition-expr tag

You can have one Condition-list inside another.
Using java is bit more complicated. let me know if you want to know that as well

On 8/3/06, rams <[hidden email]> wrote:

> Hi All,
> Can any one suggest me how to execute nested queries and queries involving
> complex joins using OfBiz entity engine?
> Are we able to execute such queries?
> Can submit a String query to the OfBiz engine so that I can get
> GenericEntity
> List matching that query?
> Thanks in advance.
> Regards
> RamReddy
>
>
>
> This e-mail and any files transmitted with it are for the sole use of the
> intended recipient(s) and may contain confidential and privileged
> information. If you are not the intended recipient or received it in error,
> please contact the sender by reply e-mail and destroy all copies of the
> original message. Please do not copy it for any purpose or disclose its
> contents.
>
> Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved

[rams-2]

Hi  Souvik,
Thanks for the reply.
I want to know how to implement joins and nested queries in java?
Can u send me sample code fragment on how to execute complex queries
involving multiple conditions?
Regards
Ram
On Thursday 03 August 2006 2:57 pm, Souvik Saha Bhowmik wrote:

> This can be implemented both from minilang as welll as java...
>  For minilang use entitiy-condition
>  it has a sub tag called condition-list. You can use as many
> condition-list as u like. condition-list can be nested as well
>  u need to specify AND or OR tindicate whether the conditions inside
> should be ANDed or ORed.
> The conditions should be mentioned in condition-expr tag
>
> You can have one Condition-list inside another.
> Using java is bit more complicated. let me know if you want to know that as
> well
>
> On 8/3/06, rams <[hidden email]> wrote:
> > Hi All,
> > Can any one suggest me how to execute nested queries and queries
> > involving complex joins using OfBiz entity engine?
> > Are we able to execute such queries?
> > Can submit a String query to the OfBiz engine so that I can get
> > GenericEntity
> > List matching that query?
> > Thanks in advance.
> > Regards
> > RamReddy
> >
> >
> >
> > This e-mail and any files transmitted with it are for the sole use of the
> > intended recipient(s) and may contain confidential and privileged
> > information. If you are not the intended recipient or received it in
> > error, please contact the sender by reply e-mail and destroy all copies
> > of the original message. Please do not copy it for any purpose or
> > disclose its contents.
> >
> > Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights
> > Reserved

This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient or received it in error, please contact the sender by reply e-mail and destroy all copies of the original message. Please do not copy it for any purpose or disclose its contents.

Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved

[BJ Freeman]

the class EntityJoinOperator.java is where the joins are done at a low
level. there are examples if you do a search on the code for this class.



rams sent the following on 8/4/2006 2:52 AM:

> Hi  Souvik,
> Thanks for the reply.
> I want to know how to implement joins and nested queries in java?
> Can u send me sample code fragment on how to execute complex queries
> involving multiple conditions?
> Regards
> Ram
> On Thursday 03 August 2006 2:57 pm, Souvik Saha Bhowmik wrote:
>> This can be implemented both from minilang as welll as java...
>>  For minilang use entitiy-condition
>>  it has a sub tag called condition-list. You can use as many
>> condition-list as u like. condition-list can be nested as well
>>  u need to specify AND or OR tindicate whether the conditions inside
>> should be ANDed or ORed.
>> The conditions should be mentioned in condition-expr tag
>>
>> You can have one Condition-list inside another.
>> Using java is bit more complicated. let me know if you want to know that as
>> well
>>
>> On 8/3/06, rams <[hidden email]> wrote:
>>> Hi All,
>>> Can any one suggest me how to execute nested queries and queries
>>> involving complex joins using OfBiz entity engine?
>>> Are we able to execute such queries?
>>> Can submit a String query to the OfBiz engine so that I can get
>>> GenericEntity
>>> List matching that query?
>>> Thanks in advance.
>>> Regards
>>> RamReddy
>>>
>>>
>>>
>>> This e-mail and any files transmitted with it are for the sole use of the
>>> intended recipient(s) and may contain confidential and privileged
>>> information. If you are not the intended recipient or received it in
>>> error, please contact the sender by reply e-mail and destroy all copies
>>> of the original message. Please do not copy it for any purpose or
>>> disclose its contents.
>>>
>>> Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights
>>> Reserved
>
>
>
> This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient or received it in error, please contact the sender by reply e-mail and destroy all copies of the original message. Please do not copy it for any purpose or disclose its contents.
>
> Copyright Tarang Software Technologies Pvt. Ltd. 2004. All rights Reserved