Relate multiple incidents to a problem

[palmen]

We've got 80 incidents we should relate to a problem.

All these incidents are closed so we don't aloud list edit from the incident list to relate them to a problem (unless you are an admin).

Is there a good way for our problem manager to relate all these incidents in one action instead of adding them one by one?

In the problem form it's possible to add incidents from a related list, but it'll take a long time to do this manually.

All the incident numbers can be found in an excel file if that helps.

As an admin I can do this in less then a minute, but I want a way for our problem manager to be able to do this without having to ask an admin. Any suggestions?

[palmen]

This is a very good solution for us.

The only problem is how to filter out the 80 incidents from the incident number we've got in the excel file. This is the tricky question since we don't want to search for the incidents one by one. Is there some way to use a comma separated list (or similar) to show only these incidents in a list?

[Kalaiarasan Pus]

Make use of 'Is one of' query in the filter and add all the numbers from excel to that.

[Kalaiarasan Pus]

Example

[Kalaiarasan Pus]

Attaching the updates done on a Helsinki instance.

[singh2442]

In which table does the related incidents or problems get saved and how could you please explain..