Hi, I don't fully follow, but I remember that there's a function for sorting parents by matching children https://solr.apache.org/guide/solr/latest/query-guide/function-queries.html#childfieldfield-function unfortunately its' vice versa stuck in implementation https://issues.apache.org/jira/browse/SOLR-10701 Can you confirm that sort=parentfield() will suite for your problem?
On Fri, Jan 26, 2024 at 4:01 PM Frederic Font Corbera <frederic.f...@upf.edu> wrote: > Hi, > > Thanks for your suggestion. I already tried that, but unfortunately it is > not what I need because it will not sort results according the the child > score (which I need), and also it would return only one parent even if > several of its children would match. > > My current solution using the domain property of the JSON facets mode and > duplication the grouping fields in child documents works perfectly. > > Thanks a lot for your help! > > > frederic > > > -- > Frederic Font - ffont.github.io > Music Technology Group, UPF - mtg.upf.edu <https://www.upf.edu/web/mtg/> > Freesound - freesound.org > > > > On Thu, 25 Jan 2024 at 19:31, Mikhail Khludnev <m...@apache.org> wrote: > > > Probably you are talking about searching parents and then roll over > parents > > to children via > > > > > https://solr.apache.org/guide/solr/latest/query-guide/document-transformers.html#child-childdoctransformerfactory > > > > On Thu, Jan 25, 2024 at 7:16 PM Frederic Font Corbera < > > frederic.f...@upf.edu> > > wrote: > > > > > Hi Mikhail, > > > > > > Thanks a lot for your quick response! I did not know about that and > this > > > seems to be exactly what I was looking for. I did some quick tests with > > the > > > JSON facets API (previously I was using the non-JSON faceting method) > and > > > it allows me to query child document but facet by parents, just as you > > > described. This is perfect for me. > > > > > > There is one extra issue that I did not mention in my previous email > > which > > > is, similar to the faceting problem which is now solved, I have a > > grouping > > > problem because I'd like to group child document by a field of the > > parent. > > > Again I could fix that by indexing the parent fields with the child > (and > > > because I only need one field it would not be too bad in this case). > But > > > maybe there is a similar solution to that of the facets? I searched the > > > docs but could not find it. > > > > > > Thanks a lot!!! > > > > > > > > > frederic > > > > > > > > > -- > > > Frederic Font - ffont.github.io > > > Music Technology Group, UPF - mtg.upf.edu < > https://www.upf.edu/web/mtg/> > > > Freesound - freesound.org > > > > > > > > > > > > On Thu, 25 Jan 2024 at 13:02, Mikhail Khludnev <m...@apache.org> > wrote: > > > > > > > Hello Federic, > > > > It sounds like blockParent domain change see. > > > > > > > > > > > > > > https://solr.apache.org/guide/solr/latest/query-guide/json-faceting-domain-changes.html#block-join-domain-changes > > > > > > > > On Thu, Jan 25, 2024 at 12:15 PM Frederic Font Corbera < > > > > frederic.f...@upf.edu> wrote: > > > > > > > > > Hi everyone, > > > > > > > > > > I'm one of the developers behind the Freesound website ( > > > > > https://freesound.org, a sound sharing website), we use Solr as > our > > > > search > > > > > engine and I'm currently experimenting with a new feature that I'd > > like > > > > to > > > > > implement using Solr. In summary, we have a Solr index with one > > > document > > > > > per sound in our database and we do standard search operations > there. > > > > > However, I'd like to add child documents to each of the main > > documents > > > > > which include specific information about the sounds at different > > points > > > > in > > > > > time. For example, I have a main document with basic properties > like > > > > sound > > > > > title and tags, but then have N child documents that have a > timestamp > > > > field > > > > > and some extra information associated with that time stamp. Here > is > > > > > simplified example of a document that could be indexed (normally my > > > child > > > > > documents would include also dense vector fields): > > > > > > > > > > [ > > > > > { > > > > > "ID": "1", > > > > > "title": "Recording of a street ambience", > > > > > "tags": ['urban', 'ambience', 'dogs', 'birds'], > > > > > "duration": 1:21, > > > > > "events": [{ > > > > > "ID": "1/events#0", > > > > > "timestamp": 0:23, > > > > > "event_description": "Dog barking" > > > > > },{ > > > > > "ID": "1/events#1", > > > > > "timestamp": 0:47, > > > > > "event_description": "Bird calls" > > > > > },{ > > > > > "ID": "1/events#2", > > > > > "timestamp": 1:05, > > > > > "event_description": "Dog barking" > > > > > }, > > > > > ... > > > > > ] > > > > > }, > > > > > ... > > > > > ] > > > > > > > > > > What I want to achieve is to do a query that matches child > documents > > > and > > > > > sorts them according to some score, but I want to do faceting based > > on > > > > > parent document fields. For example, I want to get all documents in > > > > which a > > > > > "Dog barking" event happens (and if a document has 2 such events > like > > > in > > > > > the example, I want the document returned 2 times), I want them > > sorted > > > by > > > > > the score of the child document, but I want to include faceting > data > > > for, > > > > > e.g. the "duration" field (which refers to the parent document). > > > > > > > > > > One solution would be to duplicate all the parent document fields > in > > > > every > > > > > child document at index time. This would work, but then I would > get a > > > lot > > > > > of redundant information in the index. > > > > > > > > > > What I think would work best would be a way to extend the child > > > document > > > > > fields and include the fields of the parent at "query time". So I'd > > > like > > > > to > > > > > specify the field list with something like > > > > > "fl=timestamp,event_description,__parent__.duration". Is that > > possible? > > > > > > > > > > I tried other approaches that might work like the parent query > parser > > > > which > > > > > will return parent documents whose child documents match some > > criteria, > > > > but > > > > > this has the problems of not telling me which of the child > documents > > > > > matched the query, and also it will not sort them as expected > because > > > the > > > > > score is not propagated to the parent document. > > > > > > > > > > That is all, thanks a lot for the support! > > > > > > > > > > Cheers, > > > > > > > > > > frederic > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > Frederic Font - ffont.github.io > > > > > Music Technology Group, UPF - mtg.upf.edu < > > > https://www.upf.edu/web/mtg/> > > > > > Freesound - freesound.org > > > > > > > > > > > > > > > > > -- > > > > Sincerely yours > > > > Mikhail Khludnev > > > > > > > > > > > > > -- > > Sincerely yours > > Mikhail Khludnev > > > -- Sincerely yours Mikhail Khludnev
