From 52cf92277d5483eb50dfaf025007815b22a695b9 Mon Sep 17 00:00:00 2001
From: Paul Holden <pholden@greenhead.ac.uk>
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.17.1