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.
