about summary refs log tree commit diff
diff options
context:
space:
mode:
-rw-r--r--gn_libs/jobs/jobs.py3
1 files changed, 2 insertions, 1 deletions
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())