Using other data sources in the SQL Table Widget and preserving click-through functionality
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?