SiT! Bugs - SiT!
View Issue Details
0000811SiT!reportspublic2009-07-26 13:452013-07-13 13:59
ivan 
 
normalminorhave not tried
confirmedopen 
3.45 
 
0000811: report_incidents_by_skill.phpand report_incidents_by_engineer.php uses bodytext of "External ID" to determine escalation
$sqlL = "SELECT count(id) FROM `{$dbUpdates}` AS u ";
$sqlL .= "WHERE u.bodytext LIKE \"External ID%\" AND incidentid = '".$obj->id."'";


This is a very unreliable way to determine escalation and breaks if a language other than english is used. Or even if somebody uses the text "External ID" as part of an incident discussion.
No tags attached.
child of 0000010assigned ivan [META] Basic Escalations 
child of 0001887confirmed  [META] Store more metadata about updates on incidents 
Issue History
2009-07-26 13:45ivanNew Issue
2009-07-26 19:39ivanSummaryreport_incidents_by_skill.php uses boydtext of "External ID" to determine escalation => report_incidents_by_skill.php uses bodytext of "External ID" to determine escalation
2009-07-26 19:52paulhNote Added: 0001437
2009-07-26 19:52paulhStatusnew => acknowledged
2009-07-26 19:52paulhRelationship addedchild of 0000010
2010-02-22 13:57ivanStatusacknowledged => confirmed
2010-04-10 22:42ivanStatusconfirmed => assigned
2010-04-10 22:42ivanAssigned To => ivan
2011-06-12 17:03ivanNote Added: 0003917
2011-06-12 17:03ivanAssigned Toivan =>
2011-06-12 17:03ivanStatusassigned => confirmed
2013-03-14 19:53paulhSummaryreport_incidents_by_skill.php uses bodytext of "External ID" to determine escalation => report_incidents_by_skill.phpand report_incidents_by_engineer.php uses bodytext of "External ID" to determine escalation
2013-07-13 13:59paulhRelationship addedchild of 0001887

Notes
(0001437)
paulh   
2009-07-26 19:52   
Acknowledging this, theres quite a few FIXMES scattered around SiT for this.

It was implemented this was as at the time (and too this day) its the only way to identify if a call has been escalated in its life time, this should be resolved by Neat Escalations (Mantis 10)
(0003917)
ivan   
2011-06-12 17:03   
report_incidents_by_engineer.php uses the same method.