SQL Power Software Forum

first I think we need to be able specify order by columns on the related data setup screen, but for now I specify the order by columns in a database view and use that for the related data source table, BUT, the order in the related data pop-up still not working! I verify the problem by copy the criteria that showed on the pop-up (finally the ugly header has some usage) and paste it in a SQL client tool, I got the order that I want from there.

You might need to flush the cache.. it's possible the data was cached before you changed the view to include an ORDER BY.

Another way to defeat the cache would be to enter a nonsense search criterion into one of the search boxes, like name <> 'sdkfjlkadsjalk' or whatever.

-Jonthan

I think the dashboard just behave differently from what I except, the order in the related data pop-up is adjusted implicitly to the first column (then next) in the column list of the showing column set. since you can re-order the result set by clicking on the table header (name of the column), the behavior makes a little sense now, but it was very confusing to me.

OK.

My personal preference is probably the same as yours: by default, show the rows either in their natural order as defined by the table/view in question, or better yet allow the user who defines the related data to choose a default sort order (which would be visible to the user in the normal way, showing little arrows beside the column headers).