UFN_WEBDASHBOARDPAGE_GETTITLE
Gets the title for a web dashboard page.
Return
| Return Type |
|---|
| nvarchar(100) |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @NAME | nvarchar(200) | IN | |
| @PATH | nvarchar(1000) | IN |
Definition
Copy
CREATE function dbo.UFN_WEBDASHBOARDPAGE_GETTITLE(@NAME nvarchar(200), @PATH nvarchar(1000))
returns nvarchar(100)
as
begin
declare @TITLE nvarchar(100);
select @TITLE = TITLE from dbo.WEBDASHBOARDPAGECATALOG
inner join dbo.WEBDASHBOARDLAYOUT on WEBDASHBOARDLAYOUT.ID = WEBDASHBOARDPAGECATALOG.WEBDASHBOARDLAYOUTID
left join dbo.WEBDASHBOARDFOLDER on WEBDASHBOARDPAGECATALOG.WEBDASHBOARDFOLDERID = WEBDASHBOARDFOLDER.ID
where WEBDASHBOARDPAGECATALOG.NAME = @NAME and ((@PATH = '' and WEBDASHBOARDPAGECATALOG.WEBDASHBOARDFOLDERID is null) or WEBDASHBOARDFOLDER.PATH = @PATH);
return @TITLE;
end;