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.
Solved! Go to Solution.
Views
Replies
Total Likes
"/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
Views
Replies
Total Likes
You can get some example from here http://www.wemblog.com/2011/10/how-to-find-all-pages-modified-or.html
Yogesh
Views
Replies
Total Likes
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,
Views
Replies
Total Likes
"/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
Views
Replies
Total Likes
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...
Views
Replies
Total Likes
Views
Likes
Replies