From 52cf92277d5483eb50dfaf025007815b22a695b9 Mon Sep 17 00:00:00 2001 From: Paul Holden Date: Wed, 12 Jun 2019 16:55:44 +0100 Subject: [PATCH] MDL-64484 user: cross-DB compatible profile field ordering. --- user/filters/profilefield.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/user/filters/profilefield.php b/user/filters/profilefield.php index 2ae5f54f001..65723be4df3 100644 --- a/user/filters/profilefield.php +++ b/user/filters/profilefield.php @@ -74,7 +74,8 @@ class user_filter_profilefield extends user_filter_type { */ public function get_profile_fields() { global $DB; - if (!$fields = $DB->get_records_menu('user_info_field', null, 'name', 'id, name')) { + $order = $DB->sql_order_by_text('name'); + if (!$fields = $DB->get_records_menu('user_info_field', null, $order, 'id, name')) { return null; } $res = array(0 => get_string('anyfield', 'filters')); -- 2.43.0