Pravin, Please do not use this list for learning how to do development in ofbiz. This list is for developers of Ofbiz.
--Venkat On Thu, May 24, 2012 at 12:25 PM, pravin <pravin.ku...@venkatmangudi.com>wrote: > this is my sql query.. this answer i need to show in a drop down list.. > select * from hello_hobby where hello_hobby_id NOT IN > (select hello_hobby_id from hello_person_hobby where > hello_person_id='10000') > > Am using the following code to display the query "select hello_hobby_id > from > hello_person_hobby where hello_person_id='10000'" > > <entity-options entity-name="HelloPersonHobby" > description="${helloHobbyId}"> > <entity-constraint name="helloPersonId" operator="equals" > value="${helloPersonId}"/> > > I dono how to use for two queries > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/using-subquery-in-drop-down-list-for-two-entities-tp4632377.html > Sent from the OFBiz - Dev mailing list archive at Nabble.com. > -- Regards, Venkat