From f6c623be4aea1efdb369eae2fc126bc45fce57f6 Mon Sep 17 00:00:00 2001
From: akshay
Date: Fri, 13 Dec 2024 12:08:48 +0530
Subject: table order by year in descending order

---
 lab_details.inc | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'lab_details.inc')

diff --git a/lab_details.inc b/lab_details.inc
index 0f8ea80..57f656f 100755
--- a/lab_details.inc
+++ b/lab_details.inc
@@ -6,6 +6,7 @@ function lab_migration_completed_labs_all()
     $query = db_select('lab_migration_proposal');
     $query->fields('lab_migration_proposal');
     $query->condition('approval_status', 3);
+    $query->orderBy('expected_completion_date','DESC');
     $result = $query->execute();
     //$result = db_query($query);
     if ($result->rowCount() == 0)
@@ -48,6 +49,7 @@ function lab_migration_labs_progress_all()
     $query->fields('lab_migration_proposal');
     $query->condition('approval_status', 1);
     $query->condition('solution_status', 2);
+    $query->orderBy('approval_date','DESC');
     $result = $query->execute();
     if ($result->rowCount() == 0)
       {
-- 
cgit