Query builder for different Property | Community
Skip to main content
akhilraj
akhilraj
April 28, 2022
Solved

Query builder for different Property

  • April 28, 2022
  • 2 replies
  • 1074 views

Hi Team,

I am writing a query,

 

path=/content
type=cq:Page
1_property=@jcr:content/category_id
1_property.value=%54ceab56-c3b6-44c7-ae3f-08fc87af9045%
2_property=@jcr:content/category_parent_id
2_property.value=%54ceab56-c3b6-44c7-ae3f-08fc87af9045%
p.limit=-1

 

The requirement is to get all pages with either jcr:content/category_id  or jcr:content/category_parent_id =54ceab56-c3b6-44c7-ae3f-08fc87af9045 . But it is giving zero results eventhough there are multiple pages, What will be the issue in query?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Anmol_Bhardwaj

The requirement is to get all pages with either jcr:content/category_id  or jcr:content/category_parent_id =54ceab56-c3b6-44c7-ae3f-08fc87af9045 

 

As you stated, the requirement is to have OR. But what your query does is apply the AND function.

You need to use the group.p.or=true in your query.

Something like this : 

path=/content
type=cq:Page
group.p.or=true
group.1_group.1_property=@jcr:content/category_id
group.1_group.1_property.value=%54ceab56-c3b6-44c7-ae3f-08fc87af9045%
group.2_group.2_property=@jcr:content/category_parent_id
group.2_group.2_property.value=%54ceab56-c3b6-44c7-ae3f-08fc87af9045%
p.limit=-1

Query Reference : https://github.com/paulrohrbeck/aem-links/blob/master/querybuilder_cheatsheet.md 

2 replies

lukasz-m
Community Advisor
lukasz-mCommunity Advisor
Community Advisor
April 28, 2022

Hi @akhilraj,

Please try to add like operation. So your query could look like below.

path=/content
type=cq:Page
1_property=@jcr:content/category_id
1_property.value=%54ceab56-c3b6-44c7-ae3f-08fc87af9045%
1_property.operation=like
2_property=@jcr:content/category_parent_id
2_property.value=%54ceab56-c3b6-44c7-ae3f-08fc87af9045%
2_property.operation=like
p.limit=-1

Here are some links that could be useful in the future:

    Anmol_Bhardwaj
    Community Advisor
    Anmol_BhardwajCommunity AdvisorAccepted solution
    Community Advisor
    May 2, 2022

    The requirement is to get all pages with either jcr:content/category_id  or jcr:content/category_parent_id =54ceab56-c3b6-44c7-ae3f-08fc87af9045 

     

    As you stated, the requirement is to have OR. But what your query does is apply the AND function.

    You need to use the group.p.or=true in your query.

    Something like this : 

    path=/content
type=cq:Page
group.p.or=true
group.1_group.1_property=@jcr:content/category_id
group.1_group.1_property.value=%54ceab56-c3b6-44c7-ae3f-08fc87af9045%
group.2_group.2_property=@jcr:content/category_parent_id
group.2_group.2_property.value=%54ceab56-c3b6-44c7-ae3f-08fc87af9045%
p.limit=-1

    Query Reference : https://github.com/paulrohrbeck/aem-links/blob/master/querybuilder_cheatsheet.md 

      Terms & ConditionsAccessibility statement

      Loading footer...