I have created a database view on metric definition,metric instance and incident tables, where metric definition was built on field Assignment group such that when i click on try it in db view it gives the incident and value fields where value is the

[Ganesh61]

I have created a database view on metric definition,metric instance and incident tables, where metric definition was built on field Assignment group such that when i click on try it in db view it gives the incident and value fields where value is the reassigned group name but i wanted to get some reference fields from assignment group for reassigned groups.

[Ashutosh Munot1 · Accepted solution]

Hi,

You want fields from assignment group table? If yes then you need to use left join and bring fields from group table.

Thanks,
Ashutosh

[Ganesh61]

Yes, I need assignment group reference fields with the incidents reassigned groups.please suggest the process for this.