diff options
| -rwxr-xr-x | lab_details.inc | 2 |
1 files changed, 2 insertions, 0 deletions
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) { |