1 Reply Latest reply on Nov 10, 2015 1:22 AM by Jenny.Lardh

    Is there a way to query Incidents that are linked to Problems?

    Apprentice

      We have a query that displays all Open Problems. We want to be able to report the associated Incident that is linked to that Problem. I tried to add in the Refernce Number in the Problem Incident Collection but it just displays the Reference Id for the problem. That makes sense I think because it is a collection. Is there a way to easily do this? I also thought maybe to add a field in Problem that runs a Windows Calculation to pull in the first Reference Number int he Incident Collection and that is not working either. The calculation I tried was:

       

      import System

      static def GetAttributeValue(Problem):

        Value = Problem.IncidentProblems.Incident.Id[0]

        return Value

       

      When I load the Window it is grayed out though and when I test it, I am just getting a list of all the problems.