List All Activations on CQ Author for a Particular date

[Ehemaliges Community-Mitglied]

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.

[Yogesh_Upadhyay]

You can get some example from here http://www.wemblog.com/2011/10/how-to-find-all-pages-modified-or.html

Yogesh

[Ehemaliges Community-Mitglied]

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,

[Yogesh_Upadhyay · Accepted solution]

"/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

[Ehemaliges Community-Mitglied]

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...