USP_WEBDASHBOARDPERSONALIZATION_GETDATA
Gets a page's shared data and personalization data for the given user.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @WEBDASHBOARDPAGENAME | nvarchar(200) | IN | |
| @WEBDASHBOARDPATH | nvarchar(1000) | IN | |
| @APPUSERID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_WEBDASHBOARDPERSONALIZATION_GETDATA(@WEBDASHBOARDPAGENAME nvarchar(200),
@WEBDASHBOARDPATH nvarchar(1000),
@APPUSERID uniqueidentifier)
as
set nocount on;
select WEBDASHBOARDPERSONALIZATIONPERUSER.PAGESETTINGS USERPAGESETTINGS,
WEBDASHBOARDPERSONALIZATIONALLUSERS.PAGESETTINGS SHAREDPAGESETTINGS
from dbo.WEBDASHBOARDPAGECATALOG
left join dbo.WEBDASHBOARDPERSONALIZATIONPERUSER on WEBDASHBOARDPAGECATALOG.ID = WEBDASHBOARDPERSONALIZATIONPERUSER.WEBDASHBOARDPAGEID
and WEBDASHBOARDPERSONALIZATIONPERUSER.APPUSERID = @APPUSERID
left join dbo.WEBDASHBOARDPERSONALIZATIONALLUSERS on WEBDASHBOARDPAGECATALOG.ID = WEBDASHBOARDPERSONALIZATIONALLUSERS.WEBDASHBOARDPAGEID
left join dbo.WEBDASHBOARDFOLDER on WEBDASHBOARDPAGECATALOG.WEBDASHBOARDFOLDERID = WEBDASHBOARDFOLDER.ID
where WEBDASHBOARDPAGECATALOG.NAME = @WEBDASHBOARDPAGENAME and ((@WEBDASHBOARDPATH = '' and WEBDASHBOARDPAGECATALOG.WEBDASHBOARDFOLDERID is null) or WEBDASHBOARDFOLDER.PATH = @WEBDASHBOARDPATH);