You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Jhon Smith <do...@gmx.com> on 2016/03/09 16:51:52 UTC

How to sort docs basing on nested docs' fields

There are usual documents: products and nested documents containing different prices.
How to sort product documents basing on minimum price in nested documents.

Example:
<doc>
    <field name="id">1</field>
    <field name="doc_type">product</field>  
    <doc>
        <field name="id">2</field>
        <field name="doc_type">price</field>   
        <field name="price">100</field>
    </doc>
    <doc>
        <field name="id">3</field>
        <field name="doc_type_s">price</field>   
        <field name="price">200</field>
    </doc>	
</doc>
<doc>
    <field name="id">4</field>
    <field name="doc_type">product</field>  
    <doc>
        <field name="id">5</field>
        <field name="doc_type">price</field>   
        <field name="price">300</field>
    </doc>
    <doc>
        <field name="id">6</field>
        <field name="doc_type">price</field>   
        <field name="price">50</field>
    </doc>	
</doc>  

So 
product with id=1 has prices 100 and 200: minimum price = 100
product with id=4 has prices 300 and 50: minimum price = 50
Hence sorting in ascending order should return second document(id=4) first and first document(id=1) next.

Denormalization or storing the min price in product document itself is not an option since the actual structure and requirements are more complex.

I guess some function query should be used somehow?

Re: How to sort docs basing on nested docs' fields

Posted by Mikhail Khludnev <mk...@griddynamics.com>.
Hello,

I suppose there are a clue over there
http://blog.griddynamics.com/2015/08/scoring-join-party-in-solr-53.html

On Wed, Mar 9, 2016 at 6:51 PM, Jhon Smith <do...@gmx.com> wrote:

> There are usual documents: products and nested documents containing
> different prices.
> How to sort product documents basing on minimum price in nested documents.
>
> Example:
> <doc>
>     <field name="id">1</field>
>     <field name="doc_type">product</field>
>     <doc>
>         <field name="id">2</field>
>         <field name="doc_type">price</field>
>         <field name="price">100</field>
>     </doc>
>     <doc>
>         <field name="id">3</field>
>         <field name="doc_type_s">price</field>
>         <field name="price">200</field>
>     </doc>
> </doc>
> <doc>
>     <field name="id">4</field>
>     <field name="doc_type">product</field>
>     <doc>
>         <field name="id">5</field>
>         <field name="doc_type">price</field>
>         <field name="price">300</field>
>     </doc>
>     <doc>
>         <field name="id">6</field>
>         <field name="doc_type">price</field>
>         <field name="price">50</field>
>     </doc>
> </doc>
>
> So
> product with id=1 has prices 100 and 200: minimum price = 100
> product with id=4 has prices 300 and 50: minimum price = 50
> Hence sorting in ascending order should return second document(id=4) first
> and first document(id=1) next.
>
> Denormalization or storing the min price in product document itself is not
> an option since the actual structure and requirements are more complex.
>
> I guess some function query should be used somehow?
>



-- 
Sincerely yours
Mikhail Khludnev
Principal Engineer,
Grid Dynamics

<http://www.griddynamics.com>
<mk...@griddynamics.com>