SiT! Bugs - SiT!
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0000811SiT!reportspublic2009-07-26 13:452013-07-13 13:59
Reporterivan 
Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusconfirmedResolutionopen 
PlatformOSOS Version
Product Version3.45 
Target VersionFixed in Version 
Summary0000811: report_incidents_by_skill.phpand report_incidents_by_engineer.php uses bodytext of "External ID" to determine escalation
Description$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.
Steps To Reproduce
Additional Information
TagsNo tags attached.
Relationships
child of 0000010assigned ivan [META] Basic Escalations 
child of 0001887confirmed  [META] Store more metadata about updates on incidents 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
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.