Dashboard "Show Selected Results", Work Items No Longer Available to Open

Adrian_Paech

Hi all,

I just noticed in 7.3 of the portal, when clicking on an element within a dashboard graphic, which then displays the related work items, (as shown below), the Work Items are no longer clickable (like they were in the previous version). So there is no way for the analyst to open up the relevant job without searching for it and opening it separately.

Should I log this as a bug?

Regards,

Adrian

Joe_Burrows

Updated:

Sorry just tested and can replicate, would recommend raising this one through support

Adrian_Paech

Will do.

Thanks Joe

James_Atance

Strange, I dont have this issue running v7.3, I will attach a video to the ticket you have opened

Brian_Wiest

In my experience it has been due to the ID column.
Your screenshot shows two ID columns so it is possible the portal logic cannot pickup on the "link"
What I have done in my dashboards to to make sure the row only has one column named ID (upper required for portal logic) and then use the display name to get the parent work id (as part of the title) 

seth_coussens

I believe that Brian is correct, if you have two ID columns you will run into issues with the linking.

Adrian_Paech

Thanks for the tip. We will try adjusting our dashboard and see if that does the trick.

Adrian_Paech

We tried modifying the column titles. This Didn’t fix it, and we also removed references to the parent Work Item ID and this also didn't work.

Any other ideas?

Regards,

Adrian

Brian_Wiest

Can you share the sql query?

Adrian_Paech

This is a bug, which is now being looked at by Cireson Support.

Here is an example sql query.

SELECT [WorkItemID], [ParentWorkItemID], [AssignedUser], [Title] ,[DisplayName], [CreatedByUser], Substring (DisplayName, 8, 50) as Description

FROM [ServiceManagement].[dbo].[WorkItem]
Where
  StatusID <> 'C7B65747-F99E-C108-1E17-3C1062138FC4' and
  StatusID <> '9DE908A1-D8F1-477E-C6A2-62697042B8D9' and
  StatusID <> 'B026FDFD-89BD-490B-E1FD-A599C78D440F' and
  StatusID <> 'BD0AE7C4-3315-2EB3-7933-82DFC482DBAF' and
  StatusID <> 'EAEC5899-B13C-D107-3E1A-955DA6BF9FA7' and
  StatusID <> '21DBFCB4-05F3-FCC0-A58E-A9C48CDE3B0E' and
  StatusID <> '674E87E4-A58E-EAB0-9A05-B48881DE784C' and
  StatusID <> '2B8830B6-59F0-F574-9C2A-F4B4682F1681'
  AND (
  Title like '%procurement%' or
  Description like '%procurement')