Modern Dashboard Report Help

Hello All,

I'm trying to replicate the Widget from Legacy pages called "Custom List of Reports" This allows you to choose some reports for users to quick click on and load from the Legacy Pages. In Modern Dashboards I've been able to use the builder and some editing for this query.

SELECT TOP 10 n.Name, n.Uri, n.Type, n.Category
FROM Orion.Report n
WHERE Category LIKE 'X%'
AND n.Name IN ('y', 'z');

The problem is the Uri returns a link that won't load as it starts with swis: has anyone come up with a workaround or even another way to add links in the modern dashboard to editable URLs?

Find more posts tagged with

Reports

Mordern Dashboards

Modern Dashboard

links

Dashboards

Accepted answers

SteveK

not that familar with the URI for the Report side of things. You could probabyl get away with using replace. So instead of n.Uri you just use: replace(n.Uri,'swis:','') as Uri.

All comments

SteveK

not that familar with the URI for the Report side of things. You could probabyl get away with using replace. So instead of n.Uri you just use: replace(n.Uri,'swis:','') as Uri.

jholmes

Yeah thanks, I ended up adjusting it slightly as the URI also was returning a specific webserver not the VIP name we actually use (needed to do this to keep login).

SteveK

I did something similar for a dashboard widget. One of our departments have multiple dashboards, so they wanted a navigation option on the page to all of the various dashboards for them. All of them start with the same name, so I did a replace on the name in the select, and look for that prefix in the where clause.

SELECT replace([I].DisplayName,'DashboardPreFixHere ','') as DisplayName
, 'ALIASHERE/.../' + ToString([I].DashboardID) as DashboardURL
FROM Orion.Dashboards.Instances [I]
Where [I].DisplayName like 'DashboardPreFixHere%'
And [I].private = FALSE
And [I].IsActive = TRUE

mesverrum

I'd suspect the easiest way to do this would be something like this

SELECT n.Name, n.Uri, n.Type, n.Category, concat('/Orion/Report.aspx?ReportID=',reportid) as NameLink
FROM Orion.Report n
WHERE Category LIKE 'X%'
AND n.Name IN ('y', 'z');

Although as I read your query it does make me slightly crazy that you aliased the table Report to 'n'. God clearly intended it to be aliased to 'r' like civilized humans.