USP_DATALIST_PROFILEUPDATEFORM

Return list of form having form type as Profile Update Form

Parameters

Parameter	Parameter Type	Mode	Description
@CLIENTSITEID	int	IN	CLIENTSITEID
@FORMTYPEID	uniqueidentifier	IN	FORMTYPEID
@FORMTYPE	nvarchar(500)	IN	FORMTYPE
@ISENABLED	bit	IN	ISENABLED

Definition

Copy



CREATE procedure dbo.USP_DATALIST_PROFILEUPDATEFORM
(
@CLIENTSITEID int = NULL,
@FORMTYPEID uniqueidentifier = NULL,
@FORMTYPE nvarchar(500) = NULL,
@ISENABLED bit = 1
)
as
    set nocount on;

SELECT     
        AF.[ID],
        AF.[NAME],
        AF.[LAYOUT],
        AF.[ISDEFAULT],
        AFT.[FORMTYPE],
        AF.[FORMTYPEID],
        AF.[DATEADDED],
        AF.[DATECHANGED],
        AF.[SITEID]
FROM    
        dbo.APEXFORM AF LEFT JOIN APEXFORMTYPE AFT ON AF.FORMTYPEID=AFT.ID
WHERE   AF.SITEID=@CLIENTSITEID 
AND        AFT.FORMTYPE=@FORMTYPE 
AND        AFT.ENABLED=@ISENABLED