From 42f501207560be0934cd0d0663ad0008a065784c Mon Sep 17 00:00:00 2001 From: jerome mouneyrac Date: Wed, 13 Jan 2010 11:17:21 +0000 Subject: [PATCH] webservice MDL-20805 change NOT IN for NOT EXISTS --- admin/webservice/forms.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/admin/webservice/forms.php b/admin/webservice/forms.php index 97217c10a0..c352db204c 100644 --- a/admin/webservice/forms.php +++ b/admin/webservice/forms.php @@ -144,7 +144,7 @@ class web_service_token_form extends moodleform { //user searchable selector $sql = "SELECT user.id, user.firstname, user.lastname FROM {user} user - WHERE NOT EXISTS ( SELECT adminuser.id + WHERE NOT EXISTS ( SELECT 1 FROM {user} adminuser, {role_assignments} rassign WHERE adminuser.id=user.id AND rassign.roleid = 1 AND rassign.userid = adminuser.id) ORDER BY user.lastname"; -- 2.39.5