Thanks for your answer, Mikhail.

Florian


-----Urspr√ľngliche Nachricht-----
Von: Mikhail Khludnev [mailto:m...@apache.org] 
Gesendet: Dienstag, 6. Februar 2018 11:44
An: solr-user <solr-user@lucene.apache.org>
Betreff: Re: Sort by nested field but only in matching nested documents

Hello Florian,
No. As an alternative you can put it into q param, suppressing scoring from 
undesired clauses with ^=0

On Thu, Feb 1, 2018 at 5:22 PM, Florian Fankhauser <f.fankhau...@littera.eu>
wrote:

> Hello,
> given the following document structure (books as parent, libraries 
> having these books as children):
>
> <update>
>     <add>
>         <doc>
>             <field name="doc_type_s">book</field>
>             <field name="id">1000</field>
>             <field name="title_t">Mr. Mercedes</field>
>             <field name="autor_t">Stephen King</field>
>             <doc>
>                 <field name="doc_type_s">library</field>
>                 <field name="id">1000/100</field>
>                 <field name="acquisition_date_i">20160810</field>
>                 <field name="city_t">Innsbruck</field>
>             </doc>
>             <doc>
>                 <field name="doc_type_s">library</field>
>                 <field name="id">1000/101</field>
>                 <field name="acquisition_date_i">20180103</field>
>                 <field name="city_t">Hall</field>
>             </doc>
>         </doc>
>         <doc>
>             <field name="doc_type_s">book</field>
>             <field name="id">1001</field>
>             <field name="title_t">Noah</field>
>             <field name="autor_t">Sebastian Fitzek</field>
>             <doc>
>                 <field name="doc_type_s">library</field>
>                 <field name="id">1001/100</field>
>                 <field name="acquisition_date_i">20170810</field>
>                 <field name="city_t">Innsbruck</field>
>             </doc>
>         </doc>
>     </add>
> </update>
>
> Now i want to get all books located in libraries in city "Innsbruck", 
> sorted by acquisition date descending.
> In other words: i want to filter in the field city_i in the child 
> documents, but return only the parent document. And i want to sort by 
> the field acquisition_date_i in the child documents in descending 
> order, newest first.
>
> My first try:
> -----
>
> URL:
> http://localhost:8983/solr/test1/select?q=title_t:*&fq={!
> parent%20which=doc_type_s:book}city_t:Innsbruck&sort={!
> parent%20which=doc_type_s:book%20score=max%20v=%27%
> 2Bdoc_type_s:library%20%2B{!func}acquisition_date_i%27}%20desc
>
> URL params decoded:
> q=title_t:*
> fq={!parent which=doc_type_s:book}city_t:Innsbruck
> sort={!parent which=doc_type_s:book score=max v='+doc_type_s:library
> +{!func}acquisition_date_i'} desc
>
> Result:
> {
>   "responseHeader":{
>     "status":0,
>     "QTime":4,
>     "params":{
>       "q":"title_t:*",
>       "fq":"{!parent which=doc_type_s:book}city_t:Innsbruck",
>       "sort":"{!parent which=doc_type_s:book score=max 
> v='+doc_type_s:library +{!func}acquisition_date_i'} desc"}},
>   "response":{"numFound":2,"start":0,"docs":[
>       {
>         "doc_type_s":"book",
>         "text":["book",
>           "Mr. Mercedes",
>           "Stephen King"],
>         "id":"1000",
>         "title_t":"Mr. Mercedes",
>         "title_t_fac":"Mr. Mercedes",
>         "autor_t":"Stephen King",
>         "autor_t_fac":"Stephen King",
>         "_version_":1591205521252155392},
>       {
>         "doc_type_s":"book",
>         "text":["book",
>           "Noah",
>           "Sebastian Fitzek"],
>         "id":"1001",
>         "title_t":"Noah",
>         "title_t_fac":"Noah",
>         "autor_t":"Sebastian Fitzek",
>         "autor_t_fac":"Sebastian Fitzek",
>         "_version_":1591205521256349696}]
>   }}
>
> The result is wrong, because "Noah" should be before "Mr. Mercedes" in 
> the list. The reason is, i guess, because "Mr. Mercedes" has another 
> child document with a newer acquisition_date. But this child document 
> is not in city "Innsbruck" and should not influence the sorting.
>
> So i tried to add the city-filter to the sort-parameter as well in my 
> second try:
> -----
>
> URL:
> http://localhost:8983/solr/test1/select?q=title_t:*&fq={!
> parent%20which=doc_type_s:book}city_t:Innsbruck&sort={!
> parent%20which=doc_type_s:book%20score=max%20v=%27%
> 2Bdoc_type_s:library%20%2Bcity_t:Innsbruck%20%2B{!
> func}acquisition_date_i%27}%20desc
>
> URL params decoded:
> q=title_t:*
> fq={!parent which=doc_type_s:book}city_t:Innsbruck
> sort={!parent which=doc_type_s:book score=max v='+doc_type_s:library
> +city_t:Innsbruck +{!func}acquisition_date_i'} desc
>
> (I added "+city_t:Innsbruck" to the sort param)
>
> Result:
> {
>   "responseHeader":{
>     "status":0,
>     "QTime":3,
>     "params":{
>       "q":"title_t:*",
>       "fq":"{!parent which=doc_type_s:book}city_t:Innsbruck",
>       "sort":"{!parent which=doc_type_s:book score=max 
> v='+doc_type_s:library +city_t:Innsbruck +{!func}acquisition_date_i'} 
> desc"}},
>   "response":{"numFound":2,"start":0,"docs":[
>       {
>         "doc_type_s":"book",
>         "text":["book",
>           "Noah",
>           "Sebastian Fitzek"],
>         "id":"1001",
>         "title_t":"Noah",
>         "title_t_fac":"Noah",
>         "autor_t":"Sebastian Fitzek",
>         "autor_t_fac":"Sebastian Fitzek",
>         "_version_":1591205521256349696},
>       {
>         "doc_type_s":"book",
>         "text":["book",
>           "Mr. Mercedes",
>           "Stephen King"],
>         "id":"1000",
>         "title_t":"Mr. Mercedes",
>         "title_t_fac":"Mr. Mercedes",
>         "autor_t":"Stephen King",
>         "autor_t_fac":"Stephen King",
>         "_version_":1591205521252155392}]
>   }}
>
> Now the sorting is correct.
>
> My question:
> Is there a way to achieve the same result without having add all 
> filters to the search-param?
> In other words: is there a way to sort on a child field, but only in 
> matching child-documents?
>
>
> Thanks for your help.
>
> Florian
>



--
Sincerely yours
Mikhail Khludnev

Reply via email to