Query to get list of assets uploaded today | Community

Level 3

Solved

Query to get list of assets uploaded today

Forum|Forum|3 years ago
October 21, 2022
1 reply
805 views

I have requirement to run a report daily that provides details of all the assets uploaded that day (the day the report is created) with who uploaded the assets and missing metadata . what is the query i can use to get the list of assets which are uploaded/created the day report is generated?

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 Ravi_Pampana

Hi

Below is the query to fetch the assets which are uploaded in last 1 day

path=/content/dam/en
type=dam:Asset
relativedaterange.property=jcr:created
relativedaterange.lowerBound=-1d
p.limit=-1

Community Advisor

Accepted solution

Community Advisor

Hi

Below is the query to fetch the assets which are uploaded in last 1 day

path=/content/dam/en
type=dam:Asset
relativedaterange.property=jcr:created
relativedaterange.lowerBound=-1d
p.limit=-1

ReddyIshanviAuthor

Level 3

Thank you @ravi_pampana