I get what you are after Fredric. In fact I am after a solution for the same problem as well.
I need to be able to - search based on text chunks that I have in my child documents - use their scores to sort results - filter results based on fields from the parent document - collapse it to just one child document per parent, which has the highest score. So far the only approach I have had some success is by pushing the filter fields into child documents as well during index time. And yes that's quite a lot of duplicates to manage. Thanks, Kumar On Sat, Jan 27, 2024 at 9:51 PM Frederic Font Corbera <frederic.f...@upf.edu> wrote: > Hi, > > That might indeed be an alternative solution, but I prefer the current > solution as I can have multiple matches per parent document because I’m > actually matching children. If for example 3 child docs of the same parent > match the query, I wan’t to know all these matches so searching for > children is really what I want. The solutions for faceting and filtering at > the parent domain work perfect. And grouping child docs with a field from > their parents seems not to be possible, but I fix that by adding this field > to the child docs as well (even if I’m duplicating a small amount of > information). > > Thanks again for the help! > > > frederic > > > -- > Frederic Font - ffont.github.io > Music Technology Group, UPF - mtg.upf.edu <https://www.upf.edu/web/mtg/> > Freesound - freesound.org > > > > El dv, 26 gen. 2024 a les 20:56 Mikhail Khludnev <m...@apache.org> va > escriure: > > > 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 > > >
