Expand my Community achievements bar.

Dive into Adobe Summit 2024! Explore curated list of AEM sessions & labs, register, connect with experts, ask questions, engage, and share insights. Don't miss the excitement.
SOLVED

List All Activations on CQ Author for a Particular date

Avatar

Former Community Member

Hello Experts,

 

Is there any way to get List of All Activations happened on CQ Author for a Particular date?. I think we can get that using a particular Xpath Query but not sure how to do it.

 

 

Thanks in Advance.

1 Accepted Solution

Avatar

Correct answer by
Level 5

"/jcr:root”+<your path>+"//element(*,nt:base)[@cq:lastReplicated = xs:dateTime('"+date+"')]";

Check the date formate (It is what date time widget by default) check jar node.

Yogesh

View solution in original post

4 Replies

Avatar

Former Community Member

Thanks for the reply Yogesh,. Is there any other way to to this using Xpath like below one?.

 

Query //element(*, cq:AuditEvent)[@cq:type='Activate']

 

Thanks,

Avatar

Correct answer by
Level 5

"/jcr:root”+<your path>+"//element(*,nt:base)[@cq:lastReplicated = xs:dateTime('"+date+"')]";

Check the date formate (It is what date time widget by default) check jar node.

Yogesh

Avatar

Former Community Member

Thanks Yogesh.

 

I Also got a SQL query for getting this data. This worked for me.

select * from nt:base where jcr:path like '/path/%' and cq:lastReplicated>=TIMESTAMP '2014-03-09T16:26:06.185-04:00' and cq:lastReplicated<=TIMESTAMP '2014-03-11T15:34:15.917+02:00'

 

Thanks...