From bca0e14942962cd33c13f7be9ff83a78024cd30e Mon Sep 17 00:00:00 2001
From: Agnibho Mondal <mondal@agnibho.com>
Date: Tue, 15 Jun 2021 07:36:57 +0530
Subject: [PATCH] Minor

---
 lib/db.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/db.php b/lib/db.php
index 79d9e14..bcb192a 100644
--- 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 departure,admission;");
+    $stmt=$this->prepare("SELECT pid,ward,bed,name,diagnosis,status FROM patients WHERE status!='admitted' ORDER BY admission;");
     $result=$stmt->execute();
     return($result);
   }
-- 
2.39.5