Level 1
Level 2
Sign in to Community
Learn more
Sign in to view all badges
Expand my Community achievements bar.
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
Solved! Go to Solution.
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
Hello @Vani1012 -
SQL QUERY :
SELECT * FROM [nt:base] AS page WHERE ISDESCENDANTNODE(page, '/content/projectwebsite') AND CONTAINS(page.*, '_msm_moved')
Views
Likes
Replies