Expand my Community achievements bar.

Don’t miss the AEM Skill Exchange in SF on Nov 14—hear from industry leaders, learn best practices, and enhance your AEM strategy with practical tips.
SOLVED

Retriew list of msm-moved pages

Avatar

Level 8

we want to check all of the MSM_MOVED pages that are just sitting all over the project website

Vani1012_0-1688652863367.png

Inside each language we have so many pages and subpages, how to retriew msm_moved pages

Can anyone share the sql query

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi @Vani1012 ,

The "_msm_moved" is created when a rollout action is triggered. Using the queries you can get the result where find all pages which have to keyword.

SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.*, '"_msm_moved"')

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi @Vani1012 ,

The "_msm_moved" is created when a rollout action is triggered. Using the queries you can get the result where find all pages which have to keyword.

SELECT * FROM [nt:base] AS s WHERE CONTAINS(s.*, '"_msm_moved"')

Avatar

Community Advisor

Hello @Vani1012 -

 

SQL QUERY

 

SELECT * FROM [nt:base] AS page
WHERE ISDESCENDANTNODE(page, '/content/projectwebsite')
  AND CONTAINS(page.*, '_msm_moved')