This content has been marked as final. Show 7 replies
I'm running into the same problem, ultimately on the region defintion tab under the query source you can toggle the "Use Query-Specific Column Names and Validate Query" by switching it to the opposite that you currently have applying the changes and then setting it back. This does however clear anything you have saved in the column attributes of the report... I did a trace and for my report weather I set one column to sort by or ten the order by sticks to 45.
Thanks for the reply, Justin. But the point is to be able to do it programmatically... end users can't be going into design mode and twiddling with things.
Anyways, thanks for the contribution.
ok, it looks like if i can mimic the link generated for sortable columns, ie, http://127.0.0.1:8081/apex/f?p=118:13:6691994397634648:fsp_sort_1::RP&fsp_region_id=3945432343617540, then i'll be able to reset the sort to column 1 every time i change the source object.
just got to figure out how to do that via the branch definition... any ideas? currently i'm using a Select List with Submit item to chose the region source, and an unconditional branch
Would it be possible in your case just to permanantly set your region source to "Use Generic Column Names" ?
Would it be possible in your case just to permanantlyi'm already using that -- it's the only way to have a SQL Query (PL/SQL function body returning SQL query) region that returns different query structures depending on its calculations/processing
set your region source to "Use Generic Column Names" ?
See if http://htmldb.oracle.com/i/doc/aadm_user_pref.htm#BABHHGBI applies to your situation.
Resetting all preferences for a user would reset/clear all the stored column header sort prefererences as if the report was being run for the very first time (and your design-time default options would kick in)
that put me on the right track
i really didn't want to reset all user preferences, as i am making extensive use of them in this application
however, i did find HTMLDB_UTIL.REMOVE_SORT_PREFERENCES -- which, unfortunately, removes all sort preferences, not for a specific page or region.
hey, apex developers, how about enhancing HTMLDB_UTIL.REMOVE_SORT_PREFERENCES to allow setting/removing the sort preference for a specific page (by page number or alias) and region (by position on the page or some other reliable identifier?