USP_DATALIST_MENUPAGETITLE
Returns menu page title.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CLIENTSITESID | int | IN | Client sites id |
| @SITEPAGEID | int | IN | site page id |
| @PAGETABID | int | IN | page tab id |
Definition
Copy
CREATE procedure dbo.USP_DATALIST_MENUPAGETITLE(
@CLIENTSITESID int
,@SITEPAGEID int
,@PAGETABID int = 0
)
as
set nocount on;
BEGIN
SELECT TOP 1 i.PageTitle, i.Caption
FROM [MenuItems] i (NOLOCK)
INNER JOIN SiteContent c (NOLOCK) ON i.ContentID = c.ID
WHERE c.ClientSitesID = @CLIENTSITESID AND SitePageID = @SITEPAGEID and PageTabID = @PAGETABID
END