Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list
SOLVED

Query to identify the assets with lastmodified date dam:assetState as processing

Avatar

Level 4

I'm using AEM 6.5.10.

We are trying to identify the list of images in assets which has dam:assetState as processing.

 

Can someone help with the query to identify the assets list which has as dam:assetState as processing and also bring on the jcr:lastModified property value along with it.

 

Thanks in advance !

1 Accepted Solution

Avatar

Correct answer by
Employee

@samsundar23 

Please try this:

JCR:

path=/content/dam
type=dam:AssetContent
property=dam:assetState
property.value=processing

 

SQL2:
SELECT * FROM [dam:AssetContent] AS node
WHERE ISDESCENDANTNODE(node, "/content/dam") and [dam:assetState] = "processing"

You can iterate the results for jcr:lastModified of each of the asset.

View solution in original post

1 Reply

Avatar

Correct answer by
Employee

@samsundar23 

Please try this:

JCR:

path=/content/dam
type=dam:AssetContent
property=dam:assetState
property.value=processing

 

SQL2:
SELECT * FROM [dam:AssetContent] AS node
WHERE ISDESCENDANTNODE(node, "/content/dam") and [dam:assetState] = "processing"

You can iterate the results for jcr:lastModified of each of the asset.