Retriew list of msm-moved pages | Community
Skip to main content
V
Vani1012
Level 6
July 6, 2023
Solved

Retriew list of msm-moved pages

  • July 6, 2023
  • 2 replies
  • 775 views

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

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

Can anyone share the sql query

 

 

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 Vaibhavi_J

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"')

2 replies

Vaibhavi_J
Vaibhavi_JAccepted solution
Level 7
July 6, 2023

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"')

    Tanika02
    Tanika02
    Level 7
    July 6, 2023

    Hello @vani1012 -

     

    SQL QUERY : 

     

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

     

     

      Terms & ConditionsAccessibility statement

      Loading footer...