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:
static def GetAttributeValue(Problem):
Value = Problem.IncidentProblems.Incident.Id
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.
Below are a few articles that you might find helpful. They are all on Parent / Child linking, but it would be the same principle with Problem / Incident linking as they are all set up in the same way using a linking Object.