All our Incident response levels have an escalation at 90% to change the colour, what I am trying to do is to produce a query that will show all the incidents that have reached this escalation (ie that escalation has expired) but have not reached the next (100% and breached)
I have created a query on IM_INCIDENT_ESC_POINT, and used the following critria
Action.Action Time Is Equal to (90)
Incident.Is Breached Is Equal To (False)
Incident.Status.Is Active Is Equal To (True)
which is getting there, but we have a couple of other escalations that are at 90 minutes meaning we get a couple of ring-ins....
I then tried to add the criteria
Action.Action Time Type Is Equal To (0) (or = 1)
but when I run the query I get an error:
Results view encountered the following issue and cannot run: Input string was not in correct format
If I then Try and modify that query, I get the error:
System.FormatException: Input string was not in a correct format.
and can't run or modify it.
Am I approaching this the right way?
I had originally tried to query on the Incident Colour, but most of the colours are represented by a negative number which the Query designer does not let you enter......
Another related idea was to create a pie chart on a welcome screen that showed the number of incidents at each escalation, and be able to double click on a given segment and see all the incidents in that status.
A query on the Incident object that includes the Colour can be grouped by colour in a pie chart, but the labels are just the numeric values for the colour..... which is annoying but not a show stopper. However, again may of these numeric values are negative (eg orange = -32704) and when you double click on them you get an error:
Results view encountered the following issue and cannot run: Value of '-32704' is not a valid for 'Value'. 'Value' should be between 'Minimum' and 'Maximum'. Parameter name: Value
Double clicking works fine on White (numeric value = 16777215)