Re: using subquery in drop down list for two entities..

[Himanil Gupta]

Hello pravin,

you can fetch data from 'Forms' in your dropdown list by using '<action>' tag 
when two entities are used (namely 'helloPersonHobby' and 'hello_hobby'),
see example below:-

*_ From Widget:_*
-- ExampleFroms .xml

    <form name="ExampleForm" type="single" target="..">
       <action>
            <entity-one value-field="helloPersonHobby" 
entity-name="hello_person_hobby">
               <field-map field-name="hello_person_id" value="10000"/>
            </entity-one>
       </action>
       <field name="examplelist" title="ExampleList">
            <drop-down allow-empty="true">
                <entity-options entity-name="hello_hobby" key-field-name="hello_hobby_Id" 
description="${hello_hobby_Id}">
                    <entity-constraint name="hello_hobby_Id" operator="not-equals" 
env-name="helloPersonHobby.hello_hobby_Id"/>
                </entity-options>
           </drop-down>
        </field>
    </form>


Thanks&  regards
--
Himanil Gupta
Enterprise Software Developer
HotWax Media Indore
http://www.hotwaxmedia.com/


On 05/24/2012 12:25 PM, pravin 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.