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,
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
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
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