USP_DATALIST_FAFPAGETITLEFORPART
List of PageTitle data for part
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_FAFPAGETITLEFORPART
(
@CLIENTSITESID int
,@SITEPAGEID int
,@PAGETABID int = 0
)
AS
BEGIN
SELECT TOP 1 CASE WHEN ISNULL(i.PageTitle,'') <> '' THEN i.PageTitle ELSE Caption END AS PageTitle
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