SWQL Table Hyperlinks

Cpt_Pot

Im trying to see if anyone has attempted to create a table widget in the SW Modern Dashboard that would simply list out site names that would link directly to that site's specific dashboard. IE: Miami Office, Tampa Office, Orlando Office, then being able to click one of those tables and be taken to the dashboard I created for that specific site. Thanks

mesverrum

Just to be sure, are these site specific dashboards legacy views or modern?  The relevant query would depend on that

First one would show classic views, replace the filter in the where condition with whatever naming convention you use to identify your sites, maybe just like '% Office' based on the choices you presented

select case when viewgroupname is not null then concat( v.ViewGroupName,' - ',v.ViewTitle) else v.ViewTitle end as ViewTitle, concat('/Orion/SummaryView.aspx?ViewID=',v.ViewID) as [Link]

from orion.Views v
where v.ViewType = 'Summary'
and v.ViewTitle like '% office%'

This does the same for modern dashboards

SELECT i.DisplayName as [Modern Dashboard], concat('/apps/platform/dashboard/',i.dashboardid) as [Link]
FROM Orion.Dashboards.Instances i
where i.DisplayName like '% office'