UFN_WEBDASHBOARDPAGE_GETTSLONG
Returns the timestamp for a given web dashboard page.
Return
| Return Type |
|---|
| bigint |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @NAME | nvarchar(200) | IN | |
| @PATH | nvarchar(1000) | IN |
Definition
Copy
create function dbo.UFN_WEBDASHBOARDPAGE_GETTSLONG(@CURRENTAPPUSERID uniqueidentifier,
@NAME nvarchar(200),
@PATH nvarchar(1000))
returns bigint
as
begin
declare @TSLONG bigint;
select @TSLONG = WEBDASHBOARDPAGECATALOG.TSLONG
from dbo.WEBDASHBOARDPAGECATALOG
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 @TSLONG;
end;