Query to identify the assets with lastmodified date dam:assetState as processing | Community
Skip to main content
samsundar23
samsundar23
Level 4
Oct 31, 2022 3:36 PM UTC
Solved

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

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 !

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
krati_garg
krati_gargAccepted solution
Employee
Oct 31, 2022 4:15 PM UTC

@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 reply

1 reply

krati_garg
krati_gargAccepted solution
Employee
Oct 31, 2022 4:15 PM UTC

@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.

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...