provide list of pages with their assosciated tag

[Vani1012]

Hi All,

I want to get a list of pages and their tags under "/content/masters" whose tag value is atlas-copco:industrial-tools/expert-hub/industries/industrial_assembly

for example:

page path  : /content/masters/en                            

cq:tag: atlas-copco:industrial-tools/expert-                                    hub/industries/industrial_assembly, atlas-copco:industrial-tools/webinars

I have used this query

SELECT * FROM [cq:PageContent] AS page
WHERE ISDESCENDANTNODE([/content/masters])
AND page.[cq:tags] = 'atlas-copco:industrial-tools/expert-hub/industries/industrial_assembly'

It just gives result with page path.

Can anyone provide the query.

[Mahedi_Sabuj · Accepted solution]

If I have understood your requirement correctly, you can use the query builder to obtain paths and their associated tags as shown below. 

path = /content/masters/en
type = cq:Page
tagid = atlas-copco:industrial-tools/expert-hub/industries/industrial_assembly
tagid.property = jcr:content/cq:tags
p.hits = selective
p.properties = jcr:path jcr:content/cq:tags
p.limit = -1

[Vani1012]

@Mahedi_Sabuj I ran the query but the tag associated to it isn't displaying only page path is showing
For air-motors page it has 4 tags I want to get those tags as well with page path

Please refer screenshot How I want

[Mahedi_Sabuj]

Hi @Vani1012,

Navigate to the lower-left section and locate the "JSON QueryBuilder Link". Click on this link to access a list of page paths along with their associated tags.