aboutsummaryrefslogtreecommitdiff
path: root/guix-data-service/model/build.scm
diff options
context:
space:
mode:
Diffstat (limited to 'guix-data-service/model/build.scm')
-rw-r--r--guix-data-service/model/build.scm10
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)))