USP_SITECONTENTCATEGORIES
Returns the categories for CMS Parts for the given site
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ClientSitesID | int | IN |
Definition
Copy
create procedure dbo.USP_SITECONTENTCATEGORIES (@ClientSitesID int) as
set nocount on;
select
FolderName as Category,
FolderID as CategoryID from dbo.SiteFolders
where
Type = 7
and deleted = 0
and ClientSitesID = @ClientSitesID
order by
FolderName;