Outage Tasks Link to Incident to Problem

[Gareth Davies]

I'm feeling very confused at the moment 😞

I need to create a report that shows all incidents that meet a criteria including data from the related problem record. So far so easy, dot walk from incident to problem and job done.

However, the criteria for these incidents is they have a relationship to an outage. As there's no link from the incident table to outage I'm having to start at the outage record which takes me to task rather than incident meaning I can pull most of the incident details from the task table but that doesn't include the problem number or the ability to further walk into the problem record.

I'm clearly not understanding how this works properly, does anyone know how to accomplish this or a pointer to whatever documentation will clear up my understanding of how it works?

[Brian Lancaster]

There is a ticket number field on the outage table that refers back to the incident it was created for.

[Brian Lancaster]

Actually now that I am thinking about it.  Since there is no reference from the incident table to the outage table you may have to create a view between the task and outage which would automatically fulfill the one part of the report requirement as the view would only give you incidents that had outages.

[Gareth Davies]

I think we're at the point where I need to talk to our delivery team again then. If I've understood my overnight reading correctly an Outage <-> Incident link table would work too (we have one from Outage to Task but the data I need is in the parts of the Incident table that extend Task) but neither are within my gift to implement.

Thanks for the help, appreciate it when I'm learning how it works!