Get List of locally created pages from local country site which are not rolled out fom master | Community
Skip to main content
Level 6
October 13, 2022
Solved

Get List of locally created pages from local country site which are not rolled out fom master

  • October 13, 2022
  • 2 replies
  • 860 views

Hi All,

 

I have a MSM website, wherein I have a local country site under this path(/content/cl-ma-sp/xxx).

I want to list of locally created pages from "/content/cl-ma-sp/xxx", not coming from the master.

Can anyone share the sql2 query to retriew the results. Please find the attachments.

 

Can anyone share the query.

 

Thanks,

Vani.

 

 

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 arunpatidar

Hi,

To check if page are part of live copy or not, you must check if there is a mixin type cq:LiveRelationship in present or not and then write a sql query on that

 

The information is stored the following way .

 

- cq:LiveRelationship mixin type

Any livecopy page has such a mixin type on its jcr:content node.
If not, the page has been at some point detached, or manually created via the authoring interface outside of a Livecopy action (create or rollout)

 

- cq:LiveSyncCancelled mixin type

Added on jcr:content nodes of Livecopy pages that were suspended.

If the suspension if effective for child pages as well : a cq:isCancelledForChildren=true property is added on the same node.

2 replies

arunpatidar
Community Advisor
arunpatidarCommunity AdvisorAccepted solution
Community Advisor
October 14, 2022

Hi,

To check if page are part of live copy or not, you must check if there is a mixin type cq:LiveRelationship in present or not and then write a sql query on that

 

The information is stored the following way .

 

- cq:LiveRelationship mixin type

Any livecopy page has such a mixin type on its jcr:content node.
If not, the page has been at some point detached, or manually created via the authoring interface outside of a Livecopy action (create or rollout)

 

- cq:LiveSyncCancelled mixin type

Added on jcr:content nodes of Livecopy pages that were suspended.

If the suspension if effective for child pages as well : a cq:isCancelledForChildren=true property is added on the same node.

Arun Patidar
Saravanan_Dharmaraj
Community Advisor
Community Advisor
October 14, 2022

You can run the below XPath query in crxde and verify it. Live copies will have jcr:mixinTypes=cq:liveRelationship. 

 

XPath Query 

/jcr:root/content/cl-ma-sp/xxx//element(*, cq:Page)[jcr:content/jcr:mixinTypes and (not(jcr:like(jcr:content/jcr:mixinTypes, 'cq:LiveRelationship')))]

This should return all the pages which has jcr:mixinTypes but not have cq:LiveRelationship

 

The mixinTypes will be added moment you activate a page , it will be added with mix:versionable. 

Unpublished pages wont have  mixinTypes property.