01/03: Show finished builds on the fixed output package derivations page

[Christopher Baines]

cbaines pushed a commit to branch master
in repository data-service.

commit f868591d1c742886cb65e01c919db3b4a0900577
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Tue Feb 2 19:37:35 2021 +0000

    Show finished builds on the fixed output package derivations page
    
    Rather than scheduled builds as well, as that's not useful information.
---
 guix-data-service/model/derivation.scm | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

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
          "