How to add link to object from GRID
Marek_Lefek
Customer Advanced IT Monkey ✭✭✭
in Analytics
Is there any option to add link to Workitem or configuration item when user clink on cell . Now where clik on any row it takes him into search page.
0
Best Answers
-
Justin_Workman
Cireson Support Super IT Monkey ✭✭✭✭✭
For Work Items depending on your query, you may want to alias the WorkItemID as [Id].5 -
Tom_Hendricks
Customer Super IT Monkey ✭✭✭✭✭
I agree with @Justin_Workman on the solution for your work item rows, but I wonder if the dashboard is being extremely picky with your syntax.
To be clear, the suggestion I made specifically does not handle work items. I would not have mentioned it except that you also mentioned config items. The reason it does not address work items is because the default behavior of any grid is to try to open a work item when you click it. It only takes you to the work item search screen if it couldn't find a match.
That is what I find odd about this. It should take you to a work item.
Try changing the beginning of your SQL query slightly, to this:
This works in every dashboard I have used it in, and it should for you as well. <b>wi.WorkItemId AS [Id]</b>SELECT<br>
6
Answers
There are some bugs, and I plan to update this very soon with my copy that is running much better. One known bug is that the click event will disappear if the grid refreshes. Simple omission that I have fixed.
Config items are not one of the item types that this handles, though. It can link to the Asset Management items, but not to anything outside of that, yet. I simply do not have a destination to link to. If you have a custom page that you would like to link to, it would be pretty easy to edit this for your needs.
You may want to wait until next week for the updated version, though.
I try also to ad column with link but and SQL generate column as below <a href=" CR0000">CR0000</a> , but server delete signs. Is there other option for workitem than wrote @Tom_Hendricks ?
Even if I set "Display selected Item Details" and display it, then clicking on the item also open "Serach page" - Isnt an error?
To be clear, the suggestion I made specifically does not handle work items. I would not have mentioned it except that you also mentioned config items. The reason it does not address work items is because the default behavior of any grid is to try to open a work item when you click it. It only takes you to the work item search screen if it couldn't find a match.
That is what I find odd about this. It should take you to a work item.
Try changing the beginning of your SQL query slightly, to this:
This works in every dashboard I have used it in, and it should for you as well.
One important thing is to check casesensivity