Database View to show all groups and incidents

[AA De Vera]

Hello All,

I am trying to show all assignment groups and the incidents assigned to them. I'd like to see ALL assignment groups whether they are assigned to an incident or not.

Below is what I tried but did not achieve what is required.

[Himavamshi · Accepted solution]

Hi AA De Vera,

 

 

 

Description of columns in last screenshot

Name column--> Name of Group from Group table

Assignment Group --> Name of the Group the Incident is assigned to
Number --> Incident Number

Thanks,

Himavamshi

 

[AA De Vera]

Hello Himavamshi, do you by any chance know if it is possible to join the Groups table to the OOB incident_sla database view? The requirement has been extended and the results should also show elapsed time for the resolution of the incident.

[matthew_magee1]

See my response in your other post w/ the same topic

[mdash]

Hi,

You can try like below:

You can mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards