AEM SQL2 query to get couple of properties on multiple nodes

kalyan_chakrav1 19-06-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Arun_Patidar
MVP
24-06-2019

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

Answers (3)

Answers (3)