USP_DATALIST_FAFOFFLINEFORMTEMPLATE

Data list FAF event form template

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
@OFFLINEFORMCATEGORYCODE	tinyint	IN	Offline form category code

Definition

Copy



CREATE procedure dbo.USP_DATALIST_FAFOFFLINEFORMTEMPLATE(
  @EVENTID uniqueidentifier,
  @OFFLINEFORMCATEGORYCODE tinyint = null
)
as
    set nocount on;

    select ID,
       OFFLINEFORMCATEGORYCODE,
       OFFLINEFORMCATEGORY,
       OFFLINEFORMCONTENT
    from dbo.FAFOFFLINEFORMTEMPLATE
    where EVENTID = @EVENTID 
    AND (@OFFLINEFORMCATEGORYCODE is null OR OFFLINEFORMCATEGORYCODE = @OFFLINEFORMCATEGORYCODE)