You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Manoj Mokashi <Ma...@AnjuSoftware.com> on 2021/03/02 14:00:10 UTC
Filter by sibling ?
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.
RE: Filter by sibling ?
Posted by Manoj Mokashi <Ma...@AnjuSoftware.com>.
I tried passing a parent parser connected to the {!child} parser using query params, and it seems to work !
q=type:C1 AND AND {!child of='type:PR' v=$statusqry}
statusqry={!parent which='type:PR' }type:C2
Note that my real query is not exactly this, so I haven't tried the exact expression above
-----Original Message-----
From: Manoj Mokashi <Ma...@AnjuSoftware.com>
Sent: Wednesday, March 3, 2021 9:56 AM
To: solr-user@lucene.apache.org
Subject: RE: Filter by sibling ?
Ok. Will check. thanks !
-----Original Message-----
From: Joel Bernstein <jo...@gmail.com>
Sent: Tuesday, March 2, 2021 8:48 PM
To: solr-user@lucene.apache.org
Subject: Re: Filter by sibling ?
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 <Ma...@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.
>
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.
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.
RE: Filter by sibling ?
Posted by Manoj Mokashi <Ma...@AnjuSoftware.com>.
Ok. Will check. thanks !
-----Original Message-----
From: Joel Bernstein <jo...@gmail.com>
Sent: Tuesday, March 2, 2021 8:48 PM
To: solr-user@lucene.apache.org
Subject: Re: Filter by sibling ?
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 <Ma...@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.
>
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.
Re: Filter by sibling ?
Posted by Joel Bernstein <jo...@gmail.com>.
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 <Ma...@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.
>