USP_DATAFORM_GETFIELDCHARACTERISTICS
Returns custom field characteristics for a data form field, if they exist.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATAFORMID | uniqueidentifier | IN | |
| @FIELDID | varchar(200) | IN | |
| @CULTURE | varchar(5) | IN |
Definition
Copy
create procedure dbo.USP_DATAFORM_GETFIELDCHARACTERISTICS
(
@DATAFORMID as uniqueidentifier,
@FIELDID as varchar(200),
@CULTURE as varchar(5)
)
as
begin
select top 1 FIELDID, CAPTION, ISHIDDEN, ISREQUIRED
from DATAFORMFIELDCHARACTERISTIC
join DATAFORMFIELDCHARACTERISTICCAPTION ON DATAFORMFIELDCHARACTERISTIC.ID = DATAFORMFIELDCHARACTERISTICCAPTION.DATAFORMFIELDCHARACTERISTICID
where DATAFORMINSTANCEID = @DATAFORMID and FIELDID = @FIELDID and (CULTURE = '' or CULTURE = @CULTURE)
order by CULTURE desc
end