From 3f1842894dc9f984ec2186f64c7d6f7bba27205f Mon Sep 17 00:00:00 2001
From: Frederick Muriuki Muriithi
Date: Thu, 3 Jul 2025 12:12:34 -0500
Subject: Bugfix: Fix clauses for user listing query.

---
 gn_auth/auth/authorisation/users/models.py | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'gn_auth/auth/authorisation/users/models.py')

diff --git a/gn_auth/auth/authorisation/users/models.py b/gn_auth/auth/authorisation/users/models.py
index 956f239..1b7d8e0 100644
--- a/gn_auth/auth/authorisation/users/models.py
+++ b/gn_auth/auth/authorisation/users/models.py
@@ -54,18 +54,18 @@ def __list_user_clauses_and_params__(**kwargs) -> tuple[str, dict[str, Union[int
         clauses = "email LIKE :email"
         params["email"] = f'%{kwargs["email"].strip()}%'
     elif bool(kwargs.get("name", "").strip()):
-        clauses = clauses + ["name LIKE :name"]
+        clauses = "name LIKE :name"
         params["name"] = f'%{kwargs["name"].strip()}%'
     else:
         clauses = ""
 
     if bool(kwargs.get("verified", "").strip()):
-        clauses = clauses + " AND verified=:verified"
-        params["verified"] = 1 if kwargs["verified"].strip() == "yes" else 0
+        clauses = clauses + (" AND " if len(clauses) > 0 else "") + "verified=:verified"
+        params["verified"] = "1" if kwargs["verified"].strip() == "yes" else "0"
 
     if bool(kwargs.get("age", "").strip()):
         _clause, _param = __process_age_clause__(kwargs["age"].strip())
-        clauses = clauses + f" AND {_clause}"
+        clauses = clauses + (" AND " if len(clauses) > 0 else "") + _clause
         params["created"] = _param
 
     return clauses, params
-- 
cgit v1.2.3