bringing list of Incidents onto a Problem Report

[mrswann]

Greetings!

We have a requirement for a Problem Report. There is a field called "related_incidents" which contains a count of related Incidents.

There is a related list on the Problem form of all the related incidents.

Is there anyway to pull a list of these incident numbers, into a column, for reporting against Problems?

[mrswann]

exactly! I think it's a slightly flippant request tbh

it's always interesting to explore things though + I think I learn a lot from these discussions and also gain from certain tangents. hope not a waste of other people's time...

thanks all

[Blaze2]

This is what you are looking for right? (In excel)

[Malaya]

Pls let me know if you have it resolved else I can give it a shot.

[Malaya]

I have not tried this but I think this can be achieved using notification script.. I have pulled in report from incident and change in the email body itself using script.

[mrswann]

Hi so this would be a case of generating a report within the email body?

I was envisaging some way of making a call to a function within a column (akin to an SQL Sub Query) but that is not currently possible within the reporting interface. (Wouldn't it be nice to have a custom/derived/calculated column option??)

Is your suggestion something like a script include "GetIncidentNumbersfromProblem(problem)" which would be called at each row, looping through problems ?

pseudo:

GlideRecord ( problem )

gr.Query (company, company)

gr.Query (state, open)

While (gr.Next) {

template.print ("         <tr><td> " + Problem Number + " </td> <td> " + GetIncidentNumbersfromProblem(gr.number) + "</td></tr>");

}

I guess it would be good, in terms of promoting the capability of the platform, to demonstrate the art of the possible... but is there any risk to system performance? is there a reason this is not currently included/done?

it is also nice to do things within the platform as I know we could pull this down into excel using some VBA and pretty it up - but I would go back to the point above which is a conversation I need to have, as to what is the real value? It's difficult because I would like to advocate use of the platform wherever possible but sometimes we all have to take a difficult stance for the greater good!?