KeyValueCollection order not work in complex query

Hi,

KeyValueCollection ordering in complexe query not wotking when use class.
We use delegate queries, In our project we use this to do union between entities who have same structure.

when query direct access property we have order in request

image

when access by a parent we no have order in SQL request, you can see sort in debug

image

order.zip (336.8 KB)

a not pretty solution can be use in the complex resquest a new property string for label will be work like “select newEntry.label, newEntry from …”

To reproduce
go to new entities browse
click on buton to generate 1000 row ( we new large quantity for system call delagate)
after load, ordring work

go to new entites parent browse
after load, ordering not work

CUBA Platform version: 7.2.11
CUBA Studio plugin version: 15.2-202
IntelliJ version: IntelliJ IDEA 2020.2.4 (Ultimate Edition)

best regards

gabriel

Hi.
Thank you for reporting the problem. We have created a Github issue.

Regards,
Nadezhda