Showing ordered SQL Views in FM Pro 11 Layouts and Portals

[jasonthebaldguy]

After reading the extremely simple and brief ESS documentation I have deducted that you can sort a SQL View and have that sorted view show up in a portal or on a layout. However I cannot for the life of me figure out how to get this done?

any data views or layouts all show a seemingly randomly sorted bunch of records.

The only thing that I can figure is that by choosing a "unique identifier" when I add the table I am unintentionally specifying the sort value? unfortunately I want to sort the non-unique values!

I am actually allowing the user to select the sort field in FMP and the view will dynamically use the new "sorting field choice" to re-sort the view by doing an "order by case" since sql can sort much faster this will be great to allow dynamically sorting portals