Sort list of queries in web UI for display (#14428)

jsteemann · Simran-B · web-flow · commit 5976f89f8ce5 · 2021-07-01T09:56:32.000+02:00
Co-authored-by: Simran &lt;Simran-B@users.noreply.github.com&gt;
diff --git a/CHANGELOG b/CHANGELOG
@@ -1,6 +1,13 @@
 devel
 -----
 
+* Fix display of running and slow queries in web UI when there are multiple
+  coordinators. Previously, the display order of queries was undefined, which
+  could lead to queries from one coordinator being display on top once and
+  then the queries from another. That made using this UI harder than necessary.
+  
+  Now queries are sorted for display, according to their query IDs. 
+
 * Updated ArangoDB Starter to 0.15.1-preview-2.
 
 * Fix potential stack overflow when executing large queries. This is
diff --git a/js/apps/system/_admin/aardvark/APP/frontend/js/views/queryManagementView.js b/js/apps/system/_admin/aardvark/APP/frontend/js/views/queryManagementView.js
@@ -233,6 +233,18 @@
               '',
               ''
             ]);
+          } else {
+            // sort by query id, descending
+            rowsArray = rowsArray.sort(function(l, r) {
+              // normalize both inputs to strings (in case they are numbers)
+              l = String(l[0]).padStart(20, "0");
+              r = String(r[0]).padStart(20, "0");
+
+              if (l === r) {
+                return 0;
+              }
+              return l < r ? 1 : -1;
+            });
           }
 
           self.tableDescription.rows = rowsArray;
