To get all Published page list within specific date

Question

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

krati_garg · Accepted Answer

For Sites:path=/contenttype=cq:Pagerelativedaterange.property=jcr:content/cq:lastReplicatedrelativedate.lowerBound=20d For Assets:path=/content/damtype=dam:Assetrelativedaterange.property=jcr:content/cq:lastReplicatedrelativedate.lowerBound=20d

Jagadeesh_Prakash · Answer

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, "") AND p.[jcr:content/jcr:lastModified] >= CAST("" 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, “"") AND p.[jcr:content/jcr:lastModified] >= CAST("" AS DATE) AND p.[jcr:content/jcr:lastModified] <= CAST(“” 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)

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded