In JCR-SQL2, comparing dates for this case directly is not possible because `cq:lastModified` and `cq:lastReplicated` are dynamic operands. However, the QueryBuilder API allows date comparisons using the `daterange` keyword, as documented here: Query builder cheatsheet For reference searches, we rel...

Thank you for your response, @EstebanBustamante.We are leveraging the existing features provided by ACS Commons Reports, such as returning assets with simple queries and adding columns via components. Therefore, we don't want to create a new feature from scratch.I have observed that in JCR-SQL2, it'...

Was able to do 50% of the above requirement.SELECT parent.*FROM [cq:Page] AS parentINNER JOIN [nt:base] AS childON ISDESCENDANTNODE(child, parent)WHERE ISDESCENDANTNODE(parent, '/content/project/page-path')AND (CONTAINS(child.*, '/content/dam/project/asset-path'))Adding query for date will be pretty...

I'm working on creating a reference report using the ACS Commons Reports tool in AEM.The goal of this report is to allow users to enter an asset path and generate a list of pages where the asset is used. The report includes columns such as the containing page, modified date, and replicated date.Howe...

I'm attempting to construct a query to retrieve assets based on a selected JCR node type. I'm attempting to compare the nodeType variable within the following condition.I have added condition:{{#if '{{nodeType}}' == 'dam:Asset'}}From the above observation, it is noted that I am encountering this exc...