USP_DATALIST_ISNEWFAFREGISTRATIONFLOW

Parameters

Parameter Parameter Type Mode Description
@SITEPAGEID int IN

Definition

Copy


create procedure dbo.USP_DATALIST_ISNEWFAFREGISTRATIONFLOW
(
  @SITEPAGEID integer
) with execute as owner
as
    set nocount on;

select AF.ID from PageContent PC
inner join SITECONTENT SC on PC.SiteContentID=SC.ID and SC.ContentTypesID=121
inner join APEXFORMCONTENT AC on SC.Guid = AC.ID
inner join APEXFORM AF on AC.FORMID = AF.ID and AF.FORMTYPEID='0B29CBAA-0B53-47CC-B6B9-B96311299584'
where PC.SitePagesID=@SITEPAGEID