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 >
