Mercurial > sci

annotate sql/job-list.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
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 FROM `job`
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
4 WHERE `project_name` = ?
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
5 ORDER BY `date` ASC
7e10cace67a3 scid: add basic mustache support
David Demelier <markand@malikania.fr>
parents:
diff changeset
6 LIMIT ?