Views 1 sorting seems to behave oddly.

By this I mean that if a table view contains sortable columns, but you also configure a "sort order" on the view, the sort configured on the view happens AFTER any sort the user might select, making the selectable sort columns useless.

My particular requirement is that I want a view to be sorted randomly when it is first opened, but allow the user to override this with a sort on a particular column.

Column-based sorts don't offer a "random" option, this can only be achieved by setting a random sort on the view itself, but this stops the user sort options from working, so the view will ALWAYS be randomly sorted!

Seems like a weird way to do it, or am I missing something?

Regards: colin_e