Drilldown to Saved Dashboard Options

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 DateRangeUrl – view 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, @startDate, 127)), 127) + ‘ – ‘
+ CONVERT(varchar, (CONVERT(datetimeoffset, @endDate, 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.