diff options
| -rw-r--r-- | guix-data-service/model/build.scm | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/guix-data-service/model/build.scm b/guix-data-service/model/build.scm index 8ec0af2..972a16a 100644 --- a/guix-data-service/model/build.scm +++ b/guix-data-service/model/build.scm @@ -253,7 +253,11 @@ SELECT build_servers.url, 'timestamp', build_status.timestamp, 'status', build_status.status ) - ORDER BY build_status.timestamp + ORDER BY CASE WHEN status = 'scheduled' THEN -2 + WHEN status = 'started' THEN -1 + ELSE 0 + END ASC, + timestamp ASC ) FROM build_status WHERE build_status.build_id = builds.id @@ -295,7 +299,11 @@ SELECT build_servers.url, 'timestamp', build_status.timestamp, 'status', build_status.status ) - ORDER BY build_status.timestamp + ORDER BY CASE WHEN status = 'scheduled' THEN -2 + WHEN status = 'started' THEN -1 + ELSE 0 + END ASC, + timestamp ASC ) FROM build_status WHERE build_status.build_id = builds.id |