The stored procedure should return only one value. URL template structure is the following:
/view/:Id/:filters/:comparisons/:fullScreen/:drilldown/:hideHeaders

Where:

/view/:Id/’ – is full URL to the Saved Dashboard. Example ‘https://example.rockdaisy.com/view/2/’.

:filters’ – Filter Variables that will be passed from the parent report. Multiple Filter Variables may be passed & separated.

:comparisons’ – comparison dashboard Filter Variable. Used only for comparison dashboards, otherwise empty – passed as /.

:fullScreen’ – parameter that hides left navigation menu if anything passed, otherwise empty – passed as /.

:drilldown’ – parameter that hides top navigation bar menu if anything passed, otherwise empty – passed as /.

:hideHeaders’ – parameter that hides top navigation bar if anything passed, otherwise empty.

Example of usage:

SELECT ‘https://sample.rockdaisy.com/view/2/@StoreId=’ + cast(@StoreId as varchar(max)) as DateRangeUrlview with one Filter Variable passed

SELECT ‘https://sample.rockdaisy.com/view/2/@StoreId=’
+ cast(@StoreId as varchar(max)) + ‘&@OrderDateRange=’
+ REPLACE(dbo.URLEncode(CONVERT(varchar, (CONVERT(datetimeoffset, dateadd(day,-30,cast(@Date as datetimeoffset)), 127)), 127) + ‘ – ‘
+ CONVERT(varchar, (CONVERT(datetimeoffset, cast(@Date as datetimeoffset), 127)), 127)), ‘%’, ‘__’)
+ ‘//true’ as DateRangeUrl

view with two Filter Variables passed, one of them is a Date Range

SELECT ‘https://sample.rockdaisy.com/view/2/@StoreId=’ + cast(@StoreId as varchar(max)) + ‘//1’ as DateRangeUrl – Full Screen mode

SELECT ‘https://sample.rockdaisy.com/view/2/@StoreId=’ + cast(@StoreId as varchar(max)) + ‘///1’ as DateRangeUrl – Drilldown mode

SELECT ‘https://sample.rockdaisy.com/view/2/@StoreId=’ + cast(@StoreId as varchar(max)) + ‘////1’ as DateRangeUrl – Hidden Header

These URLs will pass only one Filter Variable – @StoreId.