USP_DATALIST_SITECONTENTPLACEHOLDERS
Returns the encoded names of content placeholders used in a site.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SITEID | int | IN | Site ID |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_SITECONTENTPLACEHOLDERS(@SITEID int)
as
begin
set nocount on;
select distinct LPH.NAME from SiteLayouts SL
cross apply dbo.[UFN_GETLAYOUTPLACEHOLDERNAMES](SL.Content) LPH
where SL.ClientSitesID = @SITEID and not SL.Content is null
end