02/04: Use derivations.system_id in select-builds-with-context

[Christopher Baines]

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

commit 8a48960fa741b8018eccfe91a64629b7c258a2f6
Author: Christopher Baines <mail@cbaines.net>
AuthorDate: Wed Jun 9 10:35:29 2021 +0100

    Use derivations.system_id in select-builds-with-context
    
    As that table is always included in the query.
---
 guix-data-service/model/build.scm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/guix-data-service/model/build.scm 
b/guix-data-service/model/build.scm
index 0959af8..30196eb 100644
--- a/guix-data-service/model/build.scm
+++ b/guix-data-service/model/build.scm
@@ -145,7 +145,7 @@ ORDER BY status"))
             `(("guix_revisions.commit = $" . ,revision-commit))
             '())
       ,@(if system
-            `(("package_derivations.system_id = $" .
+            `(("derivations.system_id = $" .
                ,(number->string (system->system-id conn system))))
             '())
       ,@(if target