USP_DATALIST_CUSTOMFORMELEMENTDOCUMENTPART
Returns all custom form elements (file attachments) linked to a particular document part.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DOCPARTID | int | IN | DocPartID |
Definition
Copy
create procedure dbo.USP_DATALIST_CUSTOMFORMELEMENTDOCUMENTPART(@DOCPARTID int)
as
set nocount on;
select ID,
TITLE
from dbo.CustomFormElement
where [TYPEID] = 4
and SubTypeID = 16
and convert(int, convert(varchar(20), Properties.query('string(FileUploadProperties[1]/@DPID)'))) = @DOCPARTID