diff options
| author | Christopher Baines <mail@cbaines.net> | 2021-02-02 19:37:35 +0000 |
|---|---|---|
| committer | Christopher Baines <mail@cbaines.net> | 2021-02-02 19:37:35 +0000 |
| commit | f868591d1c742886cb65e01c919db3b4a0900577 (patch) | |
| tree | f52606b5c3c87639eda1426a5b0d97ab86b2f384 | |
| parent | 060df92557d5a32dbd3ae4a32c2c5725cd53e09b (diff) | |
| download | data-service-f868591d1c742886cb65e01c919db3b4a0900577.tar data-service-f868591d1c742886cb65e01c919db3b4a0900577.tar.gz | |
Show finished builds on the fixed output package derivations page
Rather than scheduled builds as well, as that's not useful information.
| -rw-r--r-- | guix-data-service/model/derivation.scm | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/guix-data-service/model/derivation.scm b/guix-data-service/model/derivation.scm index f41f55c..12a752c 100644 --- a/guix-data-service/model/derivation.scm +++ b/guix-data-service/model/derivation.scm @@ -604,7 +604,7 @@ SELECT DISTINCT ON (derivations.file_name) derivations.file_name, ( CASE - WHEN builds.id IS NULL THEN NULL + WHEN latest_build_status.status IS NULL THEN NULL ELSE json_build_object( 'build_server_id', builds.build_server_id, @@ -627,6 +627,8 @@ LEFT JOIN builds ON derivations.file_name = builds.derivation_file_name LEFT JOIN latest_build_status ON builds.id = latest_build_status.build_id + -- These are the two interesting states, so ignore builds in any other states + AND latest_build_status.status IN ('succeeded', 'failed') WHERE derivation_output_details.hash IS NOT NULL" (if after-derivation-file-name " |