How to combine two queries in AEM? | Community
Skip to main content
Anderson_Hamer
Anderson_Hamer
Level 4
August 11, 2021
Solved

How to combine two queries in AEM?

  • August 11, 2021
  • 3 replies
  • 5732 views

I am trying to get a node based on 2 conditions,
Condition number 1 - It should be /apps/myproject/templates/full-content-page template
Conditionnumber 2 - It should have property as cq:headerVal and value should be "col3"

 

I have created a query for these 2  conditions. Below query will be meet 1st condition

 

 

 

path=/content/myproject/sites/en-us 1_property=jcr:primaryType 1_property.value=cq:PageContent 2_property=cq:template 2_property.value=/apps/myproject/templates/full-content-page

 

 


This query is working for second condition

 

 

path=/content/myproject/sites/en-us 1_property=jcr:primaryType 1_property.value=nt:unstructured 2_property=cq:headerVal 2_property.value=col3

 

 

 

But it is not working when i combine these 2 queries and run

 

 

path=/content/myproject/sites/en-us 1_property=jcr:primaryType 1_property.value=cq:PageContent 2_property=cq:template 2_property.value=/apps/myproject/templates/full-content-page 3_property=jcr:primaryType 3_property.value=nt:unstructured 4_property=cq:headerVal 5_property.value=col3

 

 

I can understand  why it is not working. it is trying to find both cq:template and cq:headerVal on same node but it is actually two different type of node.  Is there any way we can merge these two queries ?

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 rampai

Hi @anderson_hamer ,

 

You may need to use JCR_SQL2 for this use case.

 

To get the node:

SELECT child.* FROM [nt:unstructured] as child INNER JOIN [cq:PageContent] as parent ON ISDESCENDANTNODE(child, parent) WHERE ISDESCENDANTNODE(parent, '/content/myproject/sites/en-us') AND child.[cq:headerVal] = 'col3' AND parent.[cq:template] ='/apps/myproject/templates/full-content-page'

 

or to get the pageContent:

 

SELECT parent.* FROM [nt:unstructured] as child INNER JOIN [cq:PageContent] as parent ON ISDESCENDANTNODE(child, parent) WHERE ISDESCENDANTNODE(parent, '/content/myproject/sites/en-us') AND child.[cq:headerVal] = 'col3' AND parent.[cq:template] ='/apps/myproject/templates/full-content-page'

 

Thanks,

Ram

3 replies

Kishore_Kumar_
Kishore_Kumar_
Level 9
August 11, 2021

hi @anderson_hamer ,

 

Can you please try with this

 

type=cq:Page
path=/content/myproject/sites/en-us
1_property=jcr:content/cq:template
1_property.value=/apps/myproject/templates/full-content-page
2_property=jcr:content/*/cq:headerVal
2_property.value=col3
path.self=true
p.limit=-1
    Anderson_Hamer
    Anderson_HamerAuthor
    Level 4
    August 11, 2021

    sorry, zero result. I think 

    jcr:content/*/cq:headerVal is not working
      Shubham_borole
      Community Advisor
      Shubham_boroleCommunity Advisor
      Community Advisor
      August 11, 2021

      Hi,

       

      Can you try this

      path=/content/myproject/sites/en-us
1_group.1_property=jcr:primaryType
1_group.1_property.value=cq:PageContent
1_group.2_property=cq:template
1_group.2_property.value=/apps/myproject/templates/full-content-page
1_group.p.and=true
2_group.3_property=jcr:primaryType
2_group.3_property.value=nt:unstructured
2_group.4_property=cq:headerVal
2_group.4_property.value=col3
2_group.p.and=true

      Also in your final query I see a 5_ in the last line, should it be 4_? Can you try below too?

      path=/content/myproject/sites/en-us
1_property=jcr:primaryType
1_property.value=cq:PageContent
2_property=cq:template
2_property.value=/apps/myproject/templates/full-content-page
3_property=jcr:primaryType
3_property.value=nt:unstructured
4_property=cq:headerVal
4_property.value=col3
        Anderson_Hamer
        Anderson_HamerAuthor
        Level 4
        August 11, 2021

        Sorry, zero result. This groping is not helping.

          rampai
          Community Advisor
          rampaiCommunity AdvisorAccepted solution
          Community Advisor
          August 11, 2021

          Hi @anderson_hamer ,

           

          You may need to use JCR_SQL2 for this use case.

           

          To get the node:

          SELECT child.* FROM [nt:unstructured] as child INNER JOIN [cq:PageContent] as parent ON ISDESCENDANTNODE(child, parent) WHERE ISDESCENDANTNODE(parent, '/content/myproject/sites/en-us') AND child.[cq:headerVal] = 'col3' AND parent.[cq:template] ='/apps/myproject/templates/full-content-page'

           

          or to get the pageContent:

           

          SELECT parent.* FROM [nt:unstructured] as child INNER JOIN [cq:PageContent] as parent ON ISDESCENDANTNODE(child, parent) WHERE ISDESCENDANTNODE(parent, '/content/myproject/sites/en-us') AND child.[cq:headerVal] = 'col3' AND parent.[cq:template] ='/apps/myproject/templates/full-content-page'

           

          Thanks,

          Ram

            Anderson_Hamer
            Anderson_HamerAuthor
            Level 4
            August 11, 2021

            Great. Thank you Ram. It works (y). Can we do index if in case of sql2 query?

              rampai
              Community Advisor
              rampaiCommunity Advisor
              Community Advisor
              August 12, 2021

              Yes @anderson_hamer. You can use the oakutils to generate the custom oakindex.

               

                Terms & ConditionsAccessibility statement

                Loading footer...