JCR SQL2 Query pages sorted by published date. | Community
Skip to main content
A
alvarof55440963
New Participant
February 10, 2019
Solved

JCR SQL2 Query pages sorted by published date.

  • February 10, 2019
  • 2 replies
  • 3553 views

Hi there. Right now I'm working on a component that will display a list of pages, sorted by the date. To do the sort I used the jcr:createdDate but the client is actually looking for a sort based on published date. That means that the articles that were published in AEM earlier in time will be shown before on the list. I have published some pages and checked the CRX to see if I get a property like jcr: publishedDate, but doesn't seem to include one. Is there a way to actually do that?

Thanks

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Gaurav-Behl

Sort on 'cq:lastReplicated' date in the SQL query

cq:lastReplicated = published date

In addition to that, you should check if  'cq:lastReplicationAction' = 'Activate'  in the query to pull only published items and filtering out 'Deactivated' items.

2 replies

A
alvarof55440963Author
New Participant
February 10, 2019

Totally. Thanks. And I can use last replicated action to check if publish or unpublished.

Gaurav-Behl
Gaurav-BehlAccepted solution
New Participant
February 10, 2019

Sort on 'cq:lastReplicated' date in the SQL query

cq:lastReplicated = published date

In addition to that, you should check if  'cq:lastReplicationAction' = 'Activate'  in the query to pull only published items and filtering out 'Deactivated' items.

Terms & ConditionsAccessibility statement

Loading footer...