USP_DATALIST_FAFHOUSEHOLDDASHBOARDPAGE
Gets the household dashboard page from an event.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CLIENTSITESID | int | IN | Client Site ID |
| @CONTENTTYPESID | int | IN | Content Types ID |
Definition
Copy
create procedure dbo.USP_DATALIST_FAFHOUSEHOLDDASHBOARDPAGE(
@CLIENTSITESID integer,
@CONTENTTYPESID integer = 133
)
as
set nocount on;
select PC.SitePagesID
from dbo.CMSOBJETSECURITYEXCEPTION OSE
inner join dbo.CMSOBJECTTASK OT on OSE.OBJECTTASKID = OT.ID
inner join dbo.SitePages SP on SP.Guid = OSE.SECUREDOBJECTGUID
inner join dbo.PageContent PC on PC.SitePagesID = SP.ID
inner join dbo.SiteContent SC on SC.ID = PC.SiteContentID and SC.ContentTypesID = @CONTENTTYPESID
where OSE.EXCEPTIONOBJECTGUID in ('BC6B6D42-C7E6-4983-9A99-09ABAE79F452','3182787B-18A8-4B5E-BCBE-B56D97A6F88B')
and SP.ClientSitesID = @CLIENTSITESID
group by SitePagesID