I want to create a report, that will show the incident based on priority change
I have created the Metric definition for the priority field
and also created a report which is on the Incident_metric table and the definition is one that I mentioned earlier.
However, this report does not take into account the previous incidents
I want it to show only those incidents whose priority has changed in the last 3 months
adding SS of the created definition and report
Help will be appreciated
Thank you in advance
I have found a workaround for the question I posted
please follow following steps to get the report
step A] create a metric definition on the priority field
- Navigate to Metric definitions (metric_definition)
- click on new
- choose a table as Incident
- choose type as field value duration
- choose field as Priority
step B] Create a script include to get the unique records having the priority actually changed
- under system definition, navigate to script include and click on new
- give the appropriate name and paste the following code(note the name of SI will be different in your case)
- save
step C] Create a report on the incident_metric table
- navigate to create a new inside report
- give title, choose table as incident_metric
- choose type as list
- choose filter as: definition is [your definition name create din first step] and sys_id(inc_sysid) is one of the
javascript: new (your Si name here followed with ()).(your function name inside SI followed with ())
(example: javascript:new ICgetMetricInstances().createMetric();)
Note: this will give you those incidents for which priority is changed actually
