I have a tabular form that I am using for a "purge" report. All columns in the form are of Plain Text type. The user can only interact with the row selector checkbox. (The design concept is that the query behind the form contains the purge criteria, but the user is allowed to make exceptions: Check the select-all checkbox, then uncheck the records to keep; AppyMRD will purge everything not unchecked.)
When I run the page, the sort indicator appears over the column, and in the direction (ascending or descending), of the last time the report was run. This is apparently stored somewhere in Apex, because the result/behavior is the same even in a different browser where the report has never been run. It is not due to browser caching.
Most of the form columns have the Sortable property set to Yes, and the sort controls are active and functioning correctly in the user interface.
One column, Date Paid, has the Default Sequence property set to 1, and Direction set to Ascending. Another column, Item ID, has the Default Sequence property set to 2, and Direction set to Descending. For what it's worth, Item ID is also the primary key defined in the database for the source table. The source query to the form does not have an Order By clause; in fact Apex will not allow one with sortable columns.
One would expect the form data to appear as if there were an Order By Date_Paid, Item_ID Desc clause on the source query. But no. Something is being hidden here, or something is broken. Any ideas? Thanks!