[Git][qa/jenkins.debian.net][master] rdn stats: order by built date as ids are not relyable

[Holger Levsen (@holger)]

Holger Levsen pushed to branch master at Debian QA / jenkins.debian.net


Commits:
8d91a5d4 by Jochen Sprickerhof at 2025-08-28T15:29:17+02:00
rdn stats: order by built date as ids are not relyable

(cherry picked from commit 89d1bb1e70930288716e6ec8b5872ea6a364558b)
Signed-off-by: Holger Levsen <holger at layer-acht.org>

- - - - -


1 changed file:

- bin/rebuilderd_stats.py


Changes:

=====================================
bin/rebuilderd_stats.py
=====================================
@@ -162,7 +162,7 @@ def main() -> None:
             " JOIN build_logs l ON r.build_log_id = l.id"
             " JOIN build_inputs i ON r.build_input_id = i.id"
             " JOIN source_packages s ON i.source_package_id = s.id"
-            f" WHERE a.status = 'BAD' {filter_release} group by a.name HAVING r.id = MAX(r.id) ORDER BY a.id"
+            f" WHERE a.status = 'BAD' {filter_release} group by a.name HAVING r.id = MAX(r.id) ORDER BY r.built_at"
         )
         api = "../api/v1"
     else:



View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/8d91a5d4120b5f4401bd33c4b159106c3866857d

-- 
View it on GitLab: https://salsa.debian.org/qa/jenkins.debian.net/-/commit/8d91a5d4120b5f4401bd33c4b159106c3866857d
You're receiving this email because of your account on salsa.debian.org.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://alioth-lists.debian.net/pipermail/qa-jenkins-scm/attachments/20250828/54fb1daa/attachment.htm>