SiT! Bugs

View Issue Details Jump to Notes ] Issue History ] Print ]
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.
TagsNo tags attached.
Attached Files

- Relationships
child of 0000010assignedivan [META] Basic Escalations 
child of 0001887confirmed [META] Store more metadata about updates on incidents 

-  Notes
User avatar (0001437)
paulh (administrator)
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)
User avatar (0003917)
ivan (administrator)
2011-06-12 17:03

report_incidents_by_engineer.php uses the same method.

- Issue History
Date Modified Username Field Change
2009-07-26 13:45 ivan New Issue
2009-07-26 19:39 ivan Summary report_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:52 paulh Note Added: 0001437
2009-07-26 19:52 paulh Status new => acknowledged
2009-07-26 19:52 paulh Relationship added child of 0000010
2010-02-22 13:57 ivan Status acknowledged => confirmed
2010-04-10 22:42 ivan Status confirmed => assigned
2010-04-10 22:42 ivan Assigned To => ivan
2011-06-12 17:03 ivan Note Added: 0003917
2011-06-12 17:03 ivan Assigned To ivan =>
2011-06-12 17:03 ivan Status assigned => confirmed
2013-03-14 19:53 paulh Summary report_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:59 paulh Relationship added child of 0001887


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker