Fix status in select-builds-with-context-by-derivation-file-name

The latest_build_status table should be used, not build_status.

1 files changed, 5 insertions, 5 deletions

diff --git a/guix-data-service/model/build.scm b/guix-data-service/model/build.scm
index a248f44..3041b67 100644
--- a/guix-data-service/model/build.scm
+++ b/guix-data-service/model/build.scm
@@ -201,19 +201,19 @@ SELECT DISTINCT ON (builds.id)
        build_servers.url,
        builds.build_server_build_id,
        builds.derivation_file_name,
-       build_status.timestamp,
-       build_status.status
+       latest_build_status.timestamp,
+       latest_build_status.status
 FROM builds
 INNER JOIN build_servers ON build_servers.id = builds.build_server_id
-INNER JOIN build_status
-  ON build_status.build_id = builds.id
+INNER JOIN latest_build_status
+  ON latest_build_status.build_id = builds.id
 INNER JOIN derivations_by_output_details_set
   ON builds.derivation_output_details_set_id =
      derivations_by_output_details_set.derivation_output_details_set_id
 INNER JOIN derivations
   ON derivations.id = derivations_by_output_details_set.derivation_id
 WHERE derivations.file_name = $1
-ORDER BY builds.id, build_status.timestamp DESC")
+ORDER BY builds.id, latest_build_status.timestamp DESC")
 
   (exec-query conn query (list derivation-file-name)))