How to create custom views on Analyst portal contain both Incident and Service Requests

Ibrahim_Hamdy

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

Justin_Workman

@Ibrahim_Hamdy
This query should be close to what you want:

SELECT 

      WorkItemId AS [Id]

  ,Title

      ,sds.DisplayString AS 'Status'

      ,AssignedUser

      

      ,AffectedUser

      

      ,CdS.DisplayString AS 'Category'

      ,tds.DisplayString AS 'SupportGroup'

      ,LastModified

      ,Created

      

  FROM [ServiceManagement].[dbo].[WorkItem] wi

  LEFT JOIN DisplayString SdS

  ON SdS.ElementID = wi.StatusId

  AND SdS.LocaleID = 'ENU'

  LEFT JOIN DisplayString TdS

  ON TdS.ElementID = wi.TierId

  AND TdS.LocaleID = 'ENU'

  LEFT JOIN DisplayString CdS

  ON CdS.ElementID = wi.CategoryId

  AND 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.

Brian_Wiest

Are you running a current version of the portal?
You can easily do this with a SQL Table widget.

Ibrahim_Hamdy

Currently running version 7, am not developer, can you please help me with step by step or detailed article...
Thanks

Brian_Wiest

All the available dashboards
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#/

Ibrahim_Hamdy

We need to create just a views to list all assigned incident & Service request for specific support group like Active Work

Justin_Workman

@Ibrahim_Hamdy
This query should be close to what you want:

SELECT 

      WorkItemId AS [Id]

  ,Title

      ,sds.DisplayString AS 'Status'

      ,AssignedUser

      

      ,AffectedUser

      

      ,CdS.DisplayString AS 'Category'

      ,tds.DisplayString AS 'SupportGroup'

      ,LastModified

      ,Created

      

  FROM [ServiceManagement].[dbo].[WorkItem] wi

  LEFT JOIN DisplayString SdS

  ON SdS.ElementID = wi.StatusId

  AND SdS.LocaleID = 'ENU'

  LEFT JOIN DisplayString TdS

  ON TdS.ElementID = wi.TierId

  AND TdS.LocaleID = 'ENU'

  LEFT JOIN DisplayString CdS

  ON CdS.ElementID = wi.CategoryId

  AND 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.

Ibrahim_Hamdy

@Brian_Wiest Thanks for your help
Justin_Workman Thanks, its working now.