Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

AEM SQL2 query to get couple of properties on multiple nodes

Avatar

Level 2

Hi,

As a requirement i need to read the tags from the page. On the page we have authored multiple components, so we need to read the couple of properties which are tags on the page and the components which we authored on the page. Could you please help on the SQL2 query/XPath query.

Thanks & Regards,

Kalyan

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

Please find XPath Query to find node if tag exists. further, you can get the path and read the properties using ValueMap or node API

(/jcr:root/content/we-retail//element(*, cq:PageContent)

[

(@cq:tags)
] | /jcr:root/content/we-retail//element(*, nt:unstructured)[(@cq:tags)])
order by @jcr:score descending

View solution in original post

4 Replies

Avatar

Employee

All Pages under /content that have cq:tags set (eg not null)

select * from [cq:Page] as page where page.[jcr:content/cq:tags] is not null and ISDESCENDANTNODE([/content])

Avatar

Level 2

Hi,

I need one property on cq;PageContent and other property on its childnode which is nt;unstructured type. Could you please help me on the SQL2 query.

Thanks & Regards,

Kalyan

Avatar

Correct answer by
Community Advisor

Hi,

Please find XPath Query to find node if tag exists. further, you can get the path and read the properties using ValueMap or node API

(/jcr:root/content/we-retail//element(*, cq:PageContent)

[

(@cq:tags)
] | /jcr:root/content/we-retail//element(*, nt:unstructured)[(@cq:tags)])
order by @jcr:score descending