Expand my Community achievements bar.

SOLVED

Query to get images uploaded in last 3 days

Avatar

Level 5

Hi Guys, what is the query i can use to get all the images which are uploaded in the last 3 days in the dam admin.

Thanks,

1 Accepted Solution

Avatar

Correct answer by
Level 10

Try using a JCR SQL2 query that uses a date search on the property jcr:created.

Here is a blog that talks about how to use date searches within a JCR SQL2 query: 

http://scottsdigitalcommunity.blogspot.ca/2015/12/using-date-values-in-jcr-sql2-queries.html

replace information such as path information and node types. 

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

Try using a JCR SQL2 query that uses a date search on the property jcr:created.

Here is a blog that talks about how to use date searches within a JCR SQL2 query: 

http://scottsdigitalcommunity.blogspot.ca/2015/12/using-date-values-in-jcr-sql2-queries.html

replace information such as path information and node types.