Skip to main content
V
Vani1012
New Participant
July 6, 2023
Solved

Retriew list of msm-moved pages

  • July 6, 2023
  • 2 replies
  • 780 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

Tanika02
Tanika02
New Participant
July 6, 2023

Hello @vani1012 -

 

SQL QUERY : 

 

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

 

 

    Vaibhavi_J
    Vaibhavi_JAccepted solution
    New Participant
    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"')

      Terms & ConditionsAccessibility statement

      Loading footer...