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
