Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
36 posts
|
Good morning!
I have problems to show the resultset from 2 tables in one form.
I did like this.
1. Modified QuoteScreens.xml / ListQuoteItems section
<entity-one entity-name="Quote" value-name="quote" auto-field-map="true"/>
<entity-and entity-name="QuoteItem" list-name="quoteItems"> <field-map env-name=" quote.quoteId" field-name="quoteId"/> </entity-and> <entity-and entity-name="Product" list-name="product"> <field-map env-name="quoteItems.productId " field-name="productId"/> </entity-and> 2. I suppose to show some fiels from quoteItems+some fields from product.
Modified QuoteForms.xml / ListQuoteItems section:
<auto-fields-entity entity-name="Product" default-field-type="display"/> ---- It shows all poduct table columns! How to select specific ????????
If I try to display any data from Product it says : field has no FieldInfo
How can I list data from product table???
Thanks,
-- / ** Вадим К. **/ _______________________________________________ Dev mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/dev |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
16 posts
|
Hi
I Think it would be better to create an entity view beteween Quote and Product joined on productId. You will call this view QuoteProductView. In you form you can call it as you call all entities. <auto-fields-entity entity-name="QuoteProductView" default-field-type="display"/> Pierre Gaudin Вадим K. wrote: > Good morning! > I have problems to show the resultset from 2 tables in one form. > I did like this. > 1. Modified QuoteScreens.xml / ListQuoteItems section > <entity-one entity-name="Quote" value-name="quote" auto-field-map="true"/> > <entity-and entity-name="QuoteItem" list-name="quoteItems"> > <field-map env-name=" quote.quoteId" field-name="quoteId"/> > </entity-and> > <entity-and entity-name="Product" list-name="product"> > <field-map env-name="quoteItems.productId " field-name="productId"/> > </entity-and> > 2. I suppose to show some fiels from quoteItems+some fields from product. > Modified QuoteForms.xml / ListQuoteItems section: > <auto-fields-entity entity-name="Product" > default-field-type="display"/> ---- It shows all poduct table columns! > How to select specific ???????? > If I try to display any data from Product it says : field has no > FieldInfo > How can I list data from product table??? > Thanks, > > > -- > / ** Вадим К. **/ > >------------------------------------------------------------------------ > > >_______________________________________________ >Dev mailing list >[hidden email] >http://lists.ofbiz.org/mailman/listinfo/dev > ... [show rest of quote] -- Pierre Gaudin, Ingénieur Etudes et Développement NEREIDE http://www.nereide.biz 33 (0)2 47 50 30 54 _______________________________________________ Dev mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/dev |
Loading... |
Reply to author |
Edit post |
Move post |
Delete this post |
Delete this post and replies |
Change post date |
Print post |
Permalink |
Raw mail |
![]() ![]() ![]() ![]() ![]() ![]() ![]() |
36 posts
|
Can you write an example how to do create a view?
// Vadim
2006/3/8, pierre <[hidden email]>:
Hi ... [show rest of quote] -- / ** Вадим К. **/ _______________________________________________ Dev mailing list [hidden email] http://lists.ofbiz.org/mailman/listinfo/dev |
Free forum by Nabble | Edit this page |