From 1fb5633042aa730d9467ad086196df99e60de151 Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Fri, 21 Apr 2023 02:44:29 +0300
Subject: auth: Fetch user group phenotypes not attached to a resource.

---
 gn3/auth/authorisation/resources/models.py | 3 +--
 1 file changed, 1 insertion(+), 2 deletions(-)

(limited to 'gn3/auth/authorisation/resources')

diff --git a/gn3/auth/authorisation/resources/models.py b/gn3/auth/authorisation/resources/models.py
index 4c71ade..2e2ff53 100644
--- a/gn3/auth/authorisation/resources/models.py
+++ b/gn3/auth/authorisation/resources/models.py
@@ -240,8 +240,7 @@ def phenotype_resource_data(
     cursor.execute(
         "SELECT * FROM phenotype_resources AS pr "
         "INNER JOIN linked_phenotype_data AS lpd "
-        "ON (pr.trait_id=lpd.dataset_or_trait_id "
-        "AND pr.dataset_type=lpd.dataset_type) "
+        "ON pr.data_link_id=lpd.data_link_id "
         "WHERE pr.resource_id=?",
         (str(resource_id),))
     return cursor.fetchall()
-- 
cgit v1.2.3