CA Service Management

  • 1.  Stored Query for Incident Stakeholders

    Posted 01-22-2015 01:28 PM

    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?



  • 2.  Re: Stored Query for Incident Stakeholders

    Former Employee
    Posted 02-02-2015 06:25 PM

    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?



  • 3.  Re: Stored Query for Incident Stakeholders

    Posted 02-02-2015 07:17 PM

    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