List All Activations on CQ Author for a Particular date | Community
Skip to main content
A
Anonymous
October 16, 2015
Solved

List All Activations on CQ Author for a Particular date

  • October 16, 2015
  • 4 replies
  • 1441 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Yogesh_Upadhyay

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

4 replies

Yogesh_Upadhyay
Yogesh_Upadhyay
Level 6
October 16, 2015

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

Yogesh

A
Anonymous
October 16, 2015

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
Yogesh_UpadhyayAccepted solution
Level 6
October 16, 2015

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

A
Anonymous
October 16, 2015

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

Terms & ConditionsAccessibility statement

Loading footer...