Stored Query for Incident Stakeholders

[Anon Anon]

I am trying to create a stored query for Stakeholders on Incidents.  The stakeholders list can contain both contacts and groups.  I would like to create a query that returns all Incidents where I am a stakeholder, or I am a member of a group which is a stakeholder.  Has anyone created a query like this?

[System]

Hi All - Any input here for Martin? Thanks! Chris

Martin Malecki wrote:

 

I am trying to create a stored query for Stakeholders on Incidents.  The stakeholders list can contain both contacts and groups.  I would like to create a query that returns all Incidents where I am a stakeholder, or I am a member of a group which is a stakeholder.  Has anyone created a query like this?

[Anon Anon]

Hi Martin,

this one should solve the first part of your query (where you are the stakeholder).

 

notify_list.cnt IN (@cnt.id)

 

Regards,

Jakub