From: Paul Holden <pholden@greenhead.ac.uk>
Date: Wed, 12 Jun 2019 15:55:44 +0000 (+0100)
Subject: MDL-64484 user: cross-DB compatible profile field ordering.
X-Git-Tag: v3.8.0-beta~705^2
X-Git-Url: http://git.moodle.org/gw?p=moodle.git;a=commitdiff_plain;h=52cf92277d5483eb50dfaf025007815b22a695b9;hp=03098df6ef35f4ecf3f42fdd3b895e9c891813b5;ds=sidebyside

MDL-64484 user: cross-DB compatible profile field ordering.
---

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'));