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