Mercurial > sci

diff sql/jobresult-list-by-job-group.sql @ 26:7e10cace67a3

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
scid: add basic mustache support
author David Demelier <markand@malikania.fr>
date Tue, 02 Aug 2022 13:24:13 +0200
parents
children dae2de19ca5d
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/sql/jobresult-list-by-job-group.sql	Tue Aug 02 13:24:13 2022 +0200
@@ -0,0 +1,7 @@
+  SELECT rowid
+       , *
+       , MAX(`date`)
+    FROM `jobresult`
+   WHERE `job_id` = ?
+GROUP BY `worker_name`
+   LIMIT ?