Sorting in a relation with a relation

Sorting a relation over another relation doesn’t work.
When I want to sort a value which is in the table it works fine, as soon as I want to sort over a relation it doesn’t work.

This works:
[attachment=1]works.png[/attachment]

This dosent’t work:
[attachment=0]doesn’t work.png[/attachment]

ttmgybta,

I just tried this and it worked fine.

Are both tables in the same server?
If not, then you cannot sort across these.

If yes, please create a small sample and file a case.

Rob

Hi Rob

Yes both tables are in the same Database.
I will create a sample solution.

ttmgybta

I couldn’t reproduce it in a sample solution.
Could it be because I’m using the framework?

By creating and testing my sample solution I realized something.
I created a sort in the relation employees_to_orders, over another relation orders_to_order_details to the field productid.
It works, but when I want to change the sorting in the gui by clicking on the label Productid, descending it doesn’t sort correct.

sort_Sample.servoy (5.47 KB)

ttmgybta,

Please file a case in our support system with the sample attached.

Rob