How to create custom views on Analyst portal contain both Incident and Service Requests
Ibrahim_Hamdy
Partner IT Monkey ✭
We need to create custom views include both assigned incident & Requests for each support group at analyst portal, if there any step by step or KB article help?
Thanks
Thanks
0
Best Answer
-
Justin_Workman
Cireson Support Super IT Monkey ✭✭✭✭✭
@Ibrahim_Hamdy
This query should be close to what you want:SELECTWorkItemId AS [Id],Title,sds.DisplayString AS 'Status',AssignedUser,AffectedUser,CdS.DisplayString AS 'Category',tds.DisplayString AS 'SupportGroup',LastModified,CreatedFROM [ServiceManagement].[dbo].[WorkItem] wiLEFT JOIN DisplayString SdSON SdS.ElementID = wi.StatusIdAND SdS.LocaleID = 'ENU'LEFT JOIN DisplayString TdSON TdS.ElementID = wi.TierIdAND TdS.LocaleID = 'ENU'LEFT JOIN DisplayString CdSON CdS.ElementID = wi.CategoryIdAND CdS.LocaleID = 'ENU'WHERE TdS.DisplayString = 'Tier 1'
Just change 'Tier 1' to the Name of the SupportGroup you want.
@Brian_Wiest has given the steps to create the widget on the page.5
Answers
You can easily do this with a SQL Table widget.
Thanks
https://support.cireson.com/KnowledgeBase/Listing#/category/Dashboards/168955e9-3a6e-d9df-dc75-5a0c4061960e
But for your specific use case, follow
Create the page
https://support.cireson.com/KnowledgeBase/View/1297#/
Create the Sql table
https://support.cireson.com/KnowledgeBase/View/1291#/
This query should be close to what you want:
Just change 'Tier 1' to the Name of the SupportGroup you want.
@Brian_Wiest has given the steps to create the widget on the page.
Justin_Workman Thanks, its working now.