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