Assets in AEM are stored as dam:Asset nodes, not nt:base or cq:image.
Metadata like cq:lastModified is stored under jcr:content/metadata.
Therefore, the correct query must use [dam:Asset] with the proper metadata path.
Options A and C are invalid because they use wrong node types or incorrect property paths.
Adobe Documentation:
“Assets are represented as dam:Asset nodes. Metadata such as lastModified is stored under jcr:content/metadata and can be queried using JCR-SQL2.”
— AEM Assets – Querying Assets
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit