Form Field show information from different entities

[Robert Gan]

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

[Malin Nicolas]

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 : [phone]
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : [phone]
Site : http://www.librenberry.net/

[Robert Gan]

mhh, ok a view-entity looks easier as I thougt before :)

thanks, I will try it this way.

[Deepak Agarwal-2]

Hey Robert,

Could you please explain what facets are here. Like  categoryFacets . What
is the significance, I mean how should I think them as.

On Tue, Jul 31, 2012 at 2:16 AM, Robert G. <[hidden email]> wrote:

> mhh, ok a view-entity looks easier as I thougt before :)
>
> thanks, I will try it this way.
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Form-Field-show-information-from-different-entities-tp4635391p4635393.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
> --
> Thanks,
> Deepak Agarwal,
>
> Paxcel Technologies Pvt Ltd.
> Hartron Complex, Sector 18, Gurgaon, India.
> E-Mail: [hidden email]
> Mobile: [phone]
>
>

[Robert Gan]

Its sth how Solr names a function.
I just named it CategoryFacet, cause I show it in my category, but it is like a product filter.


example:
product 1 productspecification: resolution = XGA and size = 19"
product 2 productspecification: resolution = WXGA and size = 20"
product 3 productspecification: resolution = SXGA and size = 24"
product 4 productspecification: resolution = SXGA and size = 17"

Now in Solr the Facet is: "Resoultion" and the FacetValue is the value (XGA, WXGA etc.).

Now i can do a filter like:
resulotion
XGA (1)
WXGA (1)
SXGA (2)

size
17" (1)
19" (1)
20" (1)
24" (1)
The (...) tells how many products are found.
when I now i.ex. click on SXGA this changes to:

resolution
SXGA (2)

size
17" (1)
24" (1)

With that I can drill down my search results just with easy solr querys...hope I explained it well (difficult with just a few sentences)

[Robert Gan]

Sorry I forgot to point out, that with a click on the filter (or doing a solr query), only the remaining products are shown or the product information (not only the counter). It differs on your configuration, whcih product information you can get from solr.

[Robert Gan]

@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 : [phone]
Site projet : http://www.neogia.org/
-------
Société LibrenBerry
Tél : [phone]
Site : http://www.librenberry.net/

[Deepak Agarwal-2]

Hello Robert,

I want to use the response of the solr result in ftl . I can see that it is
easily doable with velocity. Any idea how can we do it with ftl (freemarker)


On Tue, Jul 31, 2012 at 2:55 AM, Robert G. <[hidden email]> wrote:

> Its sth how Solr names a function.
> I just named it CategoryFacet, cause I show it in my category, but it is
> like a product filter.
>
>
> example:
> product 1 productspecification: resolution = XGA and size = 19"
> product 2 productspecification: resolution = WXGA and size = 20"
> product 3 productspecification: resolution = SXGA and size = 24"
> product 4 productspecification: resolution = SXGA and size = 17"
>
> Now in Solr the Facet is: "Resoultion" and the FacetValue is the value
> (XGA,
> WXGA etc.).
>
> Now i can do a filter like:
> *resulotion *
> XGA (1)
> WXGA (1)
> SXGA (2)
>
> *size*
> 17" (1)
> 19" (1)
> 20" (1)
> 24" (1)
> The (...) tells how many products are found.
> when I now i.ex. click on SXGA this changes to:
>
> resolution (just the headline)
> SXGA (2)
> *size*
> 17" (1)
> 24" (1)
>
> With that I can drill down my search results just with easy solr
> querys...hope I explained it well (difficult with just a few sentences)
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Form-Field-show-information-from-different-entities-tp4635391p4635395.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
> --
> Thanks,
> Deepak Agarwal,
>
> Paxcel Technologies Pvt Ltd.
> Hartron Complex, Sector 18, Gurgaon, India.
> E-Mail: [hidden email]
> Mobile: [phone]
>
>

[Robert Gan]

Hey :)

I did it with JS/Ajax, if you want to send the complete result from server side, than I would solrJ (java API for Solr), and send the results to FTL or groovy--> ftl. Than you can enumerate these results f.ex. with <list>-Tag in ftl to show them on the page. The solrJ methods are really easy i.ex.:


    //open  the connection to solr
    CommonsHttpSolrServer solr = new CommonsHttpSolrServer("http://localhost:8983/solr");

    //set the query parameter set
    ModifiableSolrParams params = new ModifiableSolrParams();    
    params.set("q", "cat:electronics");
    params.set("defType", "edismax");
    params.set("start", "0");
   
    //send the query parameter
    QueryResponse response = solr.query(params);

    //get results
    SolrDocumentList results = response.getResults();

    //i.ex. print the results
    for (int i = 0; i < results.size(); ++i) {
      System.out.println(results.get(i));
    }

Kindly

[Deepak Agarwal-2]

Only problem with ajax I see is SEO. Normally, I would like all the results
to be cached by search engines. what is your opinion for search engine
optimization here?

On Wed, Aug 22, 2012 at 1:11 PM, Robert G. <[hidden email]> wrote:

> Hey :)
>
> I did it with JS/Ajax, if you want to send the complete result from server
> side, than I would solrJ (java API for Solr), and send the results to FTL
> or
> groovy--> ftl. Than you can enumerate these results f.ex. with <list>-Tag
> in
> ftl to show them on the page. The solrJ methods are really easy i.ex.:
>
> /
>     //open  the connection to solr
>     CommonsHttpSolrServer solr = new
> CommonsHttpSolrServer("http://localhost:8983/solr");
>
>     //set the query parameter set
>     ModifiableSolrParams params = new ModifiableSolrParams();
>     params.set("q", "cat:electronics");
>     params.set("defType", "edismax");
>     params.set("start", "0");
>
>     //send the query parameter
>     QueryResponse response = solr.query(params);
>
>     //get results
>     SolrDocumentList results = response.getResults();
>
>     //i.ex. print the results
>     for (int i = 0; i < results.size(); ++i) {
>       System.out.println(results.get(i));
>     }/
>
> Kindly
>
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Form-Field-show-information-from-different-entities-tp4635391p4635879.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
> --
> Thanks,
> Deepak Agarwal,
>
> Paxcel Technologies Pvt Ltd.
> Hartron Complex, Sector 18, Gurgaon, India.
> E-Mail: [hidden email]
> Mobile: [phone]
>
>

[Robert Gan]

exactly that is my option for SEO, but i have not realized yet.