Ned, q=+{!edismax qf='title^5 summary' v=$pq} {!parent which='parent:true' score=max v=$favorsAU}&pq=great&favorsAU=#_parent_:false {!func}product(field(rating),query($AU,1))&AU=country:AU
On Tue, Jul 4, 2023 at 9:43 PM Mikhail Khludnev <m...@apache.org> wrote: > Hello Ned. > Make sure you check the guide first > https://solr.apache.org/guide/solr/latest/query-guide/searching-nested-documents.html#parent-query-parser > Note that Solr syntax is cumbersome. > Basically you need to combine two queries parent and joined parents. > q=+{!edismax qf='title^5 summary' v=$pq} {!parent which='parent:true' > score=max v='+docType:author country:Au^=10'}&pq=great > After every attempt check debugQuery=true output to make sure the query is > pared as expected. > It make sense to start with JSON Query DSL. > Good luck. > > On Tue, Jul 4, 2023 at 5:44 PM nedyalko.zhe...@freelance.de.INVALID > <nedyalko.zhe...@freelance.de.invalid> wrote: > >> >> Hello everyone, >> >> we are using Solr for about 2 years and now we want to extend our queries >> to improve the relevance. In our case we have parent and child documents >> and in some cases child documents could help us to improve the way we are >> sorting the results. The problem is we didn't find at the moment an easy >> way to boost parent documents based on their child documents and we think >> we are doing something wrong, as this is a common use case. This could be >> an example of parent and child document: >> >> - Parent document >> { >> "_parent_": true, >> "_root_": "book/1" >> "id": "book/1", >> "docType": "book", >> "title": "Great expectations" >> "summary": "... some text ..." >> } >> >> - Child document >> { >> "_parent_": false, >> "_root_": "book/1" >> "id": "author/1", >> "docType": "author", >> "name": "Charles Dickens" >> "country": "England" >> "rating": 4.6 >> } >> >> This could be a query: >> q=great >> &defType=edismax >> &qf=title^5 summary >> &fq=docType:book >> &fl=*,score >> >> Now, how to extend this query if we want to add the rating field from >> author document to the related book document score? Furthermore, what if we >> want to boost books written by Australian authors adding two times their >> rating value? In both cases, how to get only parent documents in the result? >> >> Thank you in advance. >> Ned >> > > > -- > Sincerely yours > Mikhail Khludnev > -- Sincerely yours Mikhail Khludnev