USP_DATALIST_CUSTOMFORMENTRYDOCUMENT

List of linked documents for a Custom Form Entry.

Parameters

Parameter	Parameter Type	Mode	Description
@CUSTOMFORMENTRYID	uniqueidentifier	IN	Custom Form Entry

Definition

Copy



CREATE procedure dbo.USP_DATALIST_CUSTOMFORMENTRYDOCUMENT(
  @CUSTOMFORMENTRYID uniqueidentifier
)
as
    set nocount on;

    select cfedoc.ID,
           cfedoc.CUSTOMFORMENTRYID,
           cfedoc.CUSTOMFORMELEMENTID,
           cfedoc.DOCUPLOADFILEID,
           doc.Name
    from dbo.CUSTOMFORMENTRYDOCUMENT cfedoc
    inner join dbo.DocUploadFiles doc on cfedoc.DOCUPLOADFILEID = doc.ID
    where CUSTOMFORMENTRYID = @CUSTOMFORMENTRYID