Sorting Data source

A little question for Bubble Dev Team.

I have a table that contains School and Teacher datatype. I use this table on a repeating group. I want to sort by School’s Name? Will it be possible one day to have this option directly on the ‘Sort By’ dropdown selection? I know I could add the name of the school on my SchoolTeacher table but I know that it is not the way a database should be structured. What is the solution if my School table have 10 columns?

It is also a problem for the constraint section.



Same here.
I have a Client data type which contains other data types like Country, Time Zone… etc., and I can’t sort based on those attributes (can only sort data that’s directly stored in its own table, etc. text/number/date… etc. )
Would love to see some solution soon.