Mercurial > sci

annotate sql/jobresult-list-by-job-group.sql @ 29:695637f1d8a7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
scid: first index page in javascript
author David Demelier <markand@malikania.fr>
date Thu, 04 Aug 2022 14:13:58 +0200
parents dae2de19ca5d
children eaebcc612a0d
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
26
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
1 SELECT rowid
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
2 , *
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
3 , MAX(`date`)
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
4 FROM `jobresult`
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
5 WHERE `job_id` = ?
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
6 GROUP BY `worker_name`