Expand my Community achievements bar.

Guidelines for the Responsible Use of Generative AI in the Experience Cloud Community.
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')