Home Analytics

Using other data sources in the SQL Table Widget and preserving click-through functionality

Leigh_KildayLeigh_Kilday Member Ninja IT Monkey ✭✭✭✭

My goal is to provide a tabular view of IRs assigned to Service Desk, that allows them to click-through to the IR form. Required fields are a combination of OOTB and from a class extension.

On the same SQL Server instance as the ServiceManagement db, we have a reporting db which is made up of a whole bunch of Views over the ServiceManager db.

The query returns results in the SQL Table Widget, but the row-level link results in a blank Work Item Search page.

Is there anything else I need to include in my query to successfully pass the ID to the WI search page, or is there a better way to go about this?

Best Answer


Sign In or Register to comment.