Solr's graph expressions can do this type of thing. It allows you to walk the relationships in a graph with filters:
https://lucene.apache.org/solr/guide/8_6/graph-traversal.html Joel Bernstein http://joelsolr.blogspot.com/ On Tue, Mar 2, 2021 at 9:00 AM Manoj Mokashi <manoj.moka...@anjusoftware.com> wrote: > Hi, > > If I have a nested document structure, with say parent type:PR, child 1 > type:C1 and child2 type:C2, > would it possible to fetch documents of type C1 that are children of > parents that have child2 docs with a certain condition ? > e.g. for > { type:PR, > Title: "XXX", > Children1 : [ { type:C1, city:ABC} ], > Children2 : [ { type:C2, status:Done}] > } > > Can I fetch type:C1 documents which are children of parent docs that have > child C2 docs with status:Done ? > > Regards, > manoj > > Confidentiality Notice > ==================== > This email message, including any attachments, is for the sole use of the > intended recipient and may contain confidential and privileged information. > Any unauthorized view, use, disclosure or distribution is prohibited. If > you are not the intended recipient, please contact the sender by reply > email and destroy all copies of the original message. Anju Software, Inc. > 4500 S. Lakeshore Drive, Suite 620, Tempe, AZ USA 85282. >