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