Fetch pages where last modified date is greater than last replicated date

[tnik]

Hi , I am trying to find all the pages under the site tree where last modified dates is greater than last replicated date , i am using below query which is leveraging  standard predicate to compare two date properties but i am not getting any result , though we have lots of pages satisfying this condition

path=/content/site/abc/en
type=cq:Page
dateComparison.property1=jcr:content/cq:lastModified
dateComparison.property2=jcr:content/cq:lastReplicated
dateComparison.operation= greater

This query i am running in AEM Cloud Service

Thanks

[tnik · Accepted solution]

The issue is solved using > in the operation. Thanks !!! , closing this thread

[snehwood]

Hey @tnik , what if I don't have access to Querybuilder portal and I need to execute the same scenario via query in CRXDE? Is there a way to fetch list of pages that have been modified since they were last published?

[snehwood]

expected: static operand is driving me crazy 😞