To get all Published page list within specific date | Community
Skip to main content
New Participant
November 28, 2022
Solved

To get all Published page list within specific date

  • November 28, 2022
  • 2 replies
  • 1833 views

Hi Team,

I want to list some pages and asset too which has been published in last 20 days.

I am writing below query in query builder but seems something wrong in it.

Can anyone help here

Best answer by krati_garg

For Sites:

path=/content
type=cq:Page
relativedaterange.property=jcr:content/cq:lastReplicated
relativedate.lowerBound=20d

 

For Assets:

path=/content/dam

type=dam:Asset

relativedaterange.property=jcr:content/cq:lastReplicated
relativedate.lowerBound=20d

2 replies

krati_garg
krati_gargAccepted solution
Employee
November 28, 2022

For Sites:

path=/content
type=cq:Page
relativedaterange.property=jcr:content/cq:lastReplicated
relativedate.lowerBound=20d

 

For Assets:

path=/content/dam

type=dam:Asset

relativedaterange.property=jcr:content/cq:lastReplicated
relativedate.lowerBound=20d

Jagadeesh_Prakash
New Participant
November 28, 2022

Hi @skumari1 You can modify below query to pages. It should work

 

  • If we want to get the assets modified after a particular date, we can use the query as below:

 SELECT * FROM [dam:Asset] AS p WHERE ISDESCENDANTNODE(p, "<path of assets to be traversed>") AND p.[jcr:content/jcr:lastModified] >= CAST("<date>" AS DATE)


 For example: SELECT * FROM [dam:Asset] AS p WHERE ISDESCENDANTNODE(p, "/content/dam") AND p.[jcr:content/jcr:lastModified] >= CAST("2022-04-01T10:36:00.000-05:00" AS DATE)

 

  • If we want to get the assets modified in between a particular date range, we can use the query as below:

 SELECT * FROM [dam:Asset] AS p WHERE ISDESCENDANTNODE(p, “"<path of assets to be traversed>") AND p.[jcr:content/jcr:lastModified] >= CAST("<From date>" AS DATE) AND p.[jcr:content/jcr:lastModified] <= CAST(“<To date>” AS DATE)

 

For example: SELECT * FROM [dam:Asset] AS p WHERE ISDESCENDANTNODE(p, "/content/dam") AND p.[jcr:content/jcr:lastModified] >= CAST("2022-03-01T10:36:00.000-05:00" AS DATE) AND p.[jcr:content/jcr:lastModified] <= CAST("2022-04-20T23:59:59.999Z" AS DATE)

skumari1Author
New Participant
November 28, 2022

Hi @jagadeesh_prakash 

I have to query last replicated pages/assets so i need to use cq:lastReplicated in place of "jcr:lastModified" in the query?