From 81c2a987503bb34f8399f12abbb1bd27095c601f Mon Sep 17 00:00:00 2001 From: jerome mouneyrac Date: Wed, 13 Jan 2010 11:15:31 +0000 Subject: [PATCH] webservice MDL-20805 change NOT IN for NOT EXISTS --- admin/webservice/forms.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/admin/webservice/forms.php b/admin/webservice/forms.php index e763b3e07d..97217c10a0 100644 --- a/admin/webservice/forms.php +++ b/admin/webservice/forms.php @@ -144,9 +144,9 @@ class web_service_token_form extends moodleform { //user searchable selector $sql = "SELECT user.id, user.firstname, user.lastname FROM {user} user - WHERE user.id NOT IN ( SELECT adminuser.id + WHERE NOT EXISTS ( SELECT adminuser.id FROM {user} adminuser, {role_assignments} rassign - WHERE rassign.roleid = 1 AND rassign.userid = adminuser.id) + WHERE adminuser.id=user.id AND rassign.roleid = 1 AND rassign.userid = adminuser.id) ORDER BY user.lastname"; $users = $DB->get_records_sql($sql,array()); $options = array(); -- 2.39.5