


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 !
Solved! Go to Solution.
Views
Replies
Total Likes
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.
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.