Login  Register

Dev - How to show 2 lists in a form?

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options Options
Embed post
Permalink
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Dev - How to show 2 lists in a form?

Вадим K.
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
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: Dev - How to show 2 lists in a form?

pierre-29
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
>


--
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
Reply | Threaded
Open this post in threaded view
| More
Print post
Permalink

Re: Dev - How to show 2 lists in a form?

Вадим K.
36 posts
Can you write an example how to do create a view?
 
// Vadim

 
2006/3/8, pierre <[hidden email]>:
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
>


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



--
/ ** Вадим К. **/
 
_______________________________________________
Dev mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/dev