Re: Complex queries

2008-10-21 Thread Angelo Matarazzo
Thank you David E Jones wrote: > > > This has been supported in OFBiz for quite a while. Check out the > EntityConditionSubSelect class in the Entity Engine. > > -David > > > On Oct 21, 2008, at 1:04 PM, Angelo Matarazzo wrote: > >> >> Hi,

Re: Complex queries

2008-10-21 Thread David E Jones
This has been supported in OFBiz for quite a while. Check out the EntityConditionSubSelect class in the Entity Engine. -David On Oct 21, 2008, at 1:04 PM, Angelo Matarazzo wrote: Hi, I try writing complex queries and I was wondering if there was a way to send these query to the DBMS

Complex queries

2008-10-21 Thread Angelo Matarazzo
Hi, I try writing complex queries and I was wondering if there was a way to send these query to the DBMS: "Select...where FIELD <> (select...)" . I think these sub-select are supportated by common DBMS. Or not? I have found a solution but it's external to framework: ht

how to use complex queries in java method

2007-11-01 Thread Mathius Allo
Just wondering if someone can provide guidance on where I can find useful information on how to model a more complex queries in OFBiz from java method i.e. SELECT b.* FROM SECURITY_GROUP_PERMISSION a, SECURITY_PERMISSION b where a.PERMISSION_ID = b.PERMISSION_ID and a.GROUP_ID = 'BIZADMIN