USP_DATAFORMTEMPLATE_VIEW_OLAPEXPLORERPAGEEXPRESSION
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@DATALOADED | bit | INOUT | |
@QUERYSEPARATOR | nvarchar(1) | INOUT | |
@HOSTEDSITEINFOIDQUERYPARAMETER | nvarchar(53) | INOUT |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_OLAPEXPLORERPAGEEXPRESSION
(
@DATALOADED bit = 0 output,
@QUERYSEPARATOR nvarchar(1) = null output,
@HOSTEDSITEINFOIDQUERYPARAMETER nvarchar(53) = null output
)
as
set nocount on;
set @DATALOADED = 1;
declare @DATABASEID uniqueidentifier;
declare @SITEINFOID uniqueidentifier;
declare @LINKURL nvarchar(500);
exec dbo.USP_SCHEMA_DB_GETHOSTINGLINKINFO
@DATABASEID = @DATABASEID output,
@SITEINFOID = @SITEINFOID output,
@LINKURL = @LINKURL output;
if len(@LINKURL) > 0 and @SITEINFOID <> '00000000-0000-0000-0000-000000000000'
begin
set @QUERYSEPARATOR = N'&';
set @HOSTEDSITEINFOIDQUERYPARAMETER = coalesce(N'HostedSiteInfoId=' + cast(@SITEINFOID as nvarchar(36)), N'');
end
return 0;