USP_DATALIST_CUSTOMFORMATTRIBUTESFORFORM

Returns CustomFormAttributes for

Parameters

Parameter Parameter Type Mode Description
@FORMGUID uniqueidentifier IN Form guid
@ATTRIBUTETYPE int IN Attribute type

Definition

Copy


CREATE procedure dbo.USP_DATALIST_CUSTOMFORMATTRIBUTESFORFORM(@FORMGUID uniqueidentifier, @ATTRIBUTETYPE int)
as
    set nocount on;

    select a.ENTRYID,
       a.ATTRIBUTETYPE,
       a.ATTRIBUTEVALUE,
           a.CHANGEUSERID,
           a.CHANGEDATE
    from dbo.CUSTOMFORMENTRYATTRIBUTE a
  inner join dbo.CUSTOMFORMENTRY b on a.ENTRYID = b.ENTRYID 
    where (a.ATTRIBUTETYPE = @ATTRIBUTETYPE or @ATTRIBUTETYPE = '-1') and b.FORMGUID = @FORMGUID