Fetch pages where last modified date is greater than last replicated date | Community
Skip to main content
Level 3
September 18, 2024
Solved

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

  • September 18, 2024
  • 1 reply
  • 749 views

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

Best answer by tnik

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

1 reply

tnikAuthorAccepted solution
Level 3
September 18, 2024

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

October 24, 2025

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?

October 24, 2025

expected: static operand is driving me crazy 😞