@Malin Nicolas thank you, I just tried it, and it works how I wanted to. Thanks
Malin Nicolas wrote > > Do you search to make an entity-view on your tow entites and after make > your entity-condition on it ? > > <view-entity entity-name="ProductCategoryAttributeAndFacetView"> > <member-alias .. ProductCategoryAttribute/> > <member-alias .. ProductCategoryFacet/> > <alias-all/> > <view link ... > <key-map field-name="productCategoryId" / > > ... > > Nicolas > Le 30/07/2012 20:58, Robert G. a écrit : > > Hello, >> >> in a form widget I want to show information from *two* entities. >> >> in my screen definition I can call each entity like: >> /<entity-condition entity-name="ProductCategoryAttribute" >> list="categoryAttributes" > >> <condition-expr field-name="productCategoryId" >> from-field="productCategoryId"/> >> <order-by field-name="attrSequenceNum"/> >> </entity-condition> >> >> <entity-condition entity-name="ProductCategoryFacet" >> list="categoryFacets" > >> <condition-expr field-name="productCategoryId" >> from-field="productCategoryId"/> >> </entity-condition>/ >> >> The problem is, that I want in my form to show fields from both entities, >> and also want to order both entities by a field from one entity. >> >> So I would have to do sth. like a join (in SQL), but how can I handle it >> here without creating a view-entity. >> >> i.ex. fields in entity: >> >> entity 1: pk1 pk2 name1 description1 >> entity 2: pk1 pk2 name2 description2 >> >> now in the form I want to show (as list) selected entries (i.ex. name2) >> from >> entity 2 with sane vakue in pk1. >> >> But also I want to show field value "name1" from the other entity. Cause >> they have the same field pl1, I need to get the relation to it, that I >> can >> show it in my form field. >> >> an Idea is to merge both lists, which I get from entity (lists: >> categoryAttributes and categoryFacets). But I do not really know how to >> put >> them together, that the relation between the keys is correct. >> >> can someone tell me how to handle it? >> >> Thank you in advance >> >> >> >> >> >> >> -- >> View this message in context: >> http://ofbiz.135035.n4.nabble.com/Form-Field-show-information-from-different-entities-tp4635391.html >> Sent from the OFBiz - User mailing list archive at Nabble.com. > > > -- > Nicolas MALIN > Consultant > Tél : 06.17.66.40.06 > Site projet : http://www.neogia.org/ > ------- > Société LibrenBerry > Tél : 02.48.02.56.12 > Site : http://www.librenberry.net/ > -- View this message in context: http://ofbiz.135035.n4.nabble.com/Form-Field-show-information-from-different-entities-tp4635391p4635399.html Sent from the OFBiz - User mailing list archive at Nabble.com.
