spLoadRecords_FormDisplayForms
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ContentID | int | IN |
Definition
Copy
CREATE PROCEDURE DBO.[spLoadRecords_FormDisplayForms]
(@ContentID AS int)
AS
BEGIN
SET NOCOUNT ON;
SELECT FDF.ID, FDF.DisplayName, FDF.FormID, FDF.Sequence, FDF.ContentID, FDF.FormGuid, CFD.DataSource
FROM DBO.FormDisplayForms FDF
INNER JOIN DBO.CustomFormDataSource CFD on CFD.FormGuid = FDF.FormGuid
WHERE ContentID = @ContentID
ORDER BY sequence ASC, DisplayName ASC, FormID ASC
END