USP_DATALIST_CMSSITESETTING_PRIVACYPAGE
Returns a list of the valid privacy pages specified in the CMS Site Settings table.
Definition
Copy
CREATE procedure dbo.USP_DATALIST_CMSSITESETTING_PRIVACYPAGE
as
set nocount on;
select SP.ID
from (select CAST(VALUE as int) ID from dbo.cmssitesetting where ENUMID = 5) PAGES
inner join dbo.SitePages SP on SP.ID = PAGES.ID
where SP.Deleted = 0