USP_DATALIST_FAFGETSITECONTENTONSITE
List of SiteContent by type on ClientSite.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CLIENTSITESID | int | IN | Client Sites Id |
| @CONTENTTYPE | int | IN | Content Type |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_FAFGETSITECONTENTONSITE
(
@CLIENTSITESID int,
@CONTENTTYPE int
)
as
set nocount on;
select distinct ID,
TITLE
from sitecontent
where ClientSitesID = @CLIENTSITESID
and ContentTypesID = @CONTENTTYPE
order by ID