diff options
Diffstat (limited to 'guix-data-service/model/build.scm')
-rw-r--r-- | guix-data-service/model/build.scm | 10 |
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))) |