using subquery in drop down list for two entities..

[pravin]

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

[Venkat Mangudi]

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 <[hidden email]>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

[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.