From 21cfe68a2ac2304d9c034b9d247a61e9861af666 Mon Sep 17 00:00:00 2001
From: alex <alex@alexloehr.net>
Date: Fri, 28 Nov 2025 15:23:17 +0000
Subject: [PATCH] GS-2333
---
lib/db.js | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/lib/db.js b/lib/db.js
index dd4dc76..6d95cc1 100644
--- a/lib/db.js
+++ b/lib/db.js
@@ -691,6 +691,7 @@
INNER JOIN ${database}.object_data od2 ON od2.obj_id = rf.rol_id
WHERE od.\`type\` = "crs"
AND od2.title LIKE "%admin%"
+ AND t.deleted is NULL
`
const [results] = await pool.query(q)
return results
@@ -706,7 +707,8 @@
INNER JOIN ${database}.rbac_fa rf ON rf.parent = t.ref_id
INNER JOIN ${database}.object_data od2 ON od2.obj_id = rf.rol_id
WHERE od.\`type\` = "crs"
- AND od2.title LIKE "%admin%") adminRoles
+ AND od2.title LIKE "%admin%"
+ AND t.deleted is NULL) adminRoles
WHERE adminRoles.rol_id NOT IN (SELECT ru2.rol_id
FROM ${database}.rbac_ua ru2)
`
--
Gitblit v1.8.0