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