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.
