USP_SIMPLEDATALIST_FAFSPECIALPAGE
FAFSpecialPage Simple Data List
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@EventID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_FAFSPECIALPAGE(
@EventID uniqueidentifier
) as
declare @INCLUDELOCKEDARTIFACTS bit = dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('A919502C-A2F6-4A56-9183-28E3F667916E')
declare @ClientSiteID int;
select @ClientSiteID=CLIENTSITESID from EVENTEXTENSION where EVENTID=@EventID
declare @temp table (ID int, PageName nvarchar(200), PageType nvarchar(200), Seq int)
insert @temp exec spGetSpecialPages @ClientSiteID, @INCLUDELOCKEDARTIFACTS
select
ID as VALUE,
PageName as LABEL
from @temp
order by PageName