From 7b12d6f0180fb8e807f2854689abf5fa682e5a1e Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Thu, 8 Jan 2026 10:58:56 -0600
Subject: Order user jobs from newest to oldest.

---
 gn_libs/jobs/jobs.py | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/gn_libs/jobs/jobs.py b/gn_libs/jobs/jobs.py
index 1ef6c0c..cee6e7e 100644
--- a/gn_libs/jobs/jobs.py
+++ b/gn_libs/jobs/jobs.py
@@ -66,7 +66,8 @@ def jobs_by_external_id(conn: DbConnection, external_id: Union[str, uuid.UUID])
         cursor.execute(
             "SELECT jeids.external_id, jobs.* FROM jobs_external_ids AS jeids "
             "INNER JOIN jobs ON jeids.job_id=jobs.job_id "
-            "WHERE jeids.external_id=?",
+            "WHERE jeids.external_id=? "
+            "ORDER BY jobs.created DESC",
             (str(external_id),))
         _jobs = {row["job_id"]: {**dict(row), "metadata": {}} for row in cursor.fetchall()}
         _jobs_ids = tuple(_job["job_id"] for _job in _jobs.values())
-- 
cgit 1.4.1