This issue has been created
There are 2 updates.
 
 
XWiki Platform / cid:jira-generated-image-avatar-f4555ff5-9c67-4c07-b141-6ff0804411e5 XWIKI-24564 Open

Suggested values in page and DB list picker sorting depends on the database

 
View issue   ยท   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-46a782c7-2076-463c-a59a-d021d0c049b0 Michael Hamann created this issue on 13/Jul/26 18:28
 
Summary: Suggested values in page and DB list picker sorting depends on the database
Issue Type: cid:jira-generated-image-avatar-f4555ff5-9c67-4c07-b141-6ff0804411e5 Bug
Affects Versions: 16.10.0
Assignee: Unassigned
Attachments: image-2026-07-13-18-25-20-205.png
Components: Old Core
Created: 13/Jul/26 18:28
Priority: cid:jira-generated-image-static-major-4d78c368-5ba6-4129-8164-268ddf770338 Major
Reporter: Michael Hamann
Description:

Steps to reproduce:

  1. Create a page/space SortDemo
  2. Within that space, create three pages in that order:
    1. Title: "Sortcheck Mango", name: "aaa"
    2. Title: "Sortcheck Apple", name: "mmm"
    3. Title: "Sortcheck Zebra", name: "zzz"
  3. Go to "Application Within Minutes" and start creating an application.
  4. Enter any name like "SortcheckApp" and continue to the next step.
  5. Add a "Page" field. In the preview, type "Sortcheck" and check the order of the suggestions:

Expected result:

The suggestions are displayed in alphabetic order, independent of the database. Note: the order is also modified in the UI based on the match. The page titles are chosen to be of the same length to have the same match score, in which case the order from the server is used.

Actual result:

The suggestions are displayed in a different order, that also varies depending on the database (according to CI results, it should be different on MariaDB/MySQL vs. the other databases.

45028_image-2026-07-13-18-25-20-205.png

 
 

2 updates

 
cid:jira-generated-image-avatar-46a782c7-2076-463c-a59a-d021d0c049b0 Changes by Michael Hamann on 13/Jul/26 18:29
 
Description: *Steps to reproduce:*
# Create a page/space SortDemo
# Within that space, create three pages in that order:
## Title: "Sortcheck Mango", name: "aaa"
## Title: "Sortcheck Apple", name: "mmm"
## Title: "Sortcheck Zebra", name: "zzz"
# Go to "Application Within Minutes" and start creating an application.
# Enter any name like "SortcheckApp" and continue to the next step.
# Add a "Page" field. In the preview, type "Sortcheck" and check the order of the suggestions:

*Expected result:*

The suggestions are displayed in alphabetic order, independent of the database. Note: the order is also modified in the UI based on the match. The page titles are chosen to be of the same length to have the same match score, in which case the order from the server is used.

!fixed-result.png!

*Actual result:*

The suggestions are displayed in a different order, that also varies depending on the database (according to CI results, it should be different on MariaDB/MySQL vs. the other databases.

!image-2026-07-13-18-25-20-205.png!
Attachment: fixed-result.png