[Bug]: values in relation tables are not sorted alphabetically

[InnovPlantProtect]

What is the bug? (in English)

I have a table in postgresql which has several tables related to it. Each of these tables are lists and their values need to be sorted alphabetically to facilitate the data input. In QGIS if i edit the table and add a new records, then the values of the lists appear sorted. However, when i publish the project in lizmap and i add a new record, these values do not appear in alphabetical order anymore.

Steps to reproduce the issue

Upload a table from postgres with related tables (lists). Check that the related tables (lists) are mapped in the form (see screenshot below) Then publish the project in lizmap. In lizmap open the form and add the values. As showed below the values are not sorted

Versions, safeguards, check summary etc

Versions :

• Lizmap Web Client : 3.6.9
• Lizmap plugin : 4.3.1
• QGIS Desktop : 3.34.6
• QGIS Server : 3.34.5
• Py-QGIS-Server : not used
• QGIS Server plugin atlasprint : not found
• QGIS Server plugin lizmap_server : 2.8.6
• QGIS Server plugin wfsOutputExtension : 1.8.0

List of safeguards :

* Mode : safe * Allow parent folder : no * Prevent other drive : yes * Prevent PG service : yes * Prevent PG Auth DB : yes * Force PG user&pass : yes * Prevent ECW : yes

Check Lizmap plugin

• [X] I have done the step just before in the Lizmap QGIS desktop plugin before opening this ticket. Otherwise, my ticket is not considered valid and might get closed.

Operating system

Ubuntu 22

Browsers

Firefox, Chrome

Browsers version

recent

Relevant log output

No response

[gioman]

@Gustry possibly related to https://github.com/qgis/QGIS/pull/52249

[gioman]

@Gustry Can we have some feedback here? If necessary we can revert the commit in QGIS that apparently caused this regression (if we have understand well the problem).

[Gustry]

Sorry, I don't know, I was just adding a label for triaging.