Minor

[simpleipd.git] / lib / db.php

diff --git a/lib/db.php b/lib/db.php
index 73671742d31d91cd930cb463f941a216c390a780..79d9e14c340d64ee50baf7532d9538768d4ee04d 100644 (file)
--- a/lib/db.php
+++ b/lib/db.php
@@ -404,7 +404,7 @@ class DB extends SQLite3 {
   function getArchivedPatientList(){
     global $log;
     if(!checkAccess("info", "dbGet")) return false;
-    $stmt=$this->prepare("SELECT pid,ward,bed,name,diagnosis,status FROM patients WHERE status!='admitted' ORDER BY UPPER(ward),bed;");
+    $stmt=$this->prepare("SELECT pid,ward,bed,name,diagnosis,status FROM patients WHERE status!='admitted' ORDER BY departure,admission;");
     $result=$stmt->execute();
     return($result);
   }