Expand my Community achievements bar.

SOLVED

How to generate and download a report of the asset tagged under a specific tag category?

Avatar

Level 3

How to generate and download a report of the asset tagged under a specif tag category?

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

you can write a servlet which executes a query with the above condition and put results in CSV or in Other Formats.

The query can look like below for searching Assets which tags either with we-retail:apparel/footwear or we-retail:apparel/shorts

QueryBuilder Query

type=dam:Asset

path=/content/dam

property=jcr:content/metadata/cq:tags

property.1_value=we-retail:apparel/footwear

property.2_value=we-retail:apparel/shorts

p.hits=selective

p.properties=jcr:path

p.limit=-1

The bold part from the query can be removed. That is for json output from QueryBuilder Debugger Tool to only gives assets path.

Or create your own reporting by following below:

Developing Reports



Arun Patidar

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

you can write a servlet which executes a query with the above condition and put results in CSV or in Other Formats.

The query can look like below for searching Assets which tags either with we-retail:apparel/footwear or we-retail:apparel/shorts

QueryBuilder Query

type=dam:Asset

path=/content/dam

property=jcr:content/metadata/cq:tags

property.1_value=we-retail:apparel/footwear

property.2_value=we-retail:apparel/shorts

p.hits=selective

p.properties=jcr:path

p.limit=-1

The bold part from the query can be removed. That is for json output from QueryBuilder Debugger Tool to only gives assets path.

Or create your own reporting by following below:

Developing Reports



Arun Patidar

Avatar

Level 3

Thanks Arun, will test and get back to you.