How to generate and download a report of the asset tagged under a specific tag category? | Community
Skip to main content
PiyushA1986
Level 2
June 20, 2019
Solved

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

  • June 20, 2019
  • 2 replies
  • 2710 views

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

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 arunpatidar

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

2 replies

arunpatidar
Community Advisor
arunpatidarCommunity AdvisorAccepted solution
Community Advisor
June 20, 2019

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
PiyushA1986
Level 2
June 24, 2019

Thanks Arun, will test and get back to you.