To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114187 Issue #|114187 Summary|Cannot see/remove query sorts from "order by" statemen |t in query view Component|Database access Version|OOo 3.2.1 Platform|Macintosh URL| OS/Version|Mac OS X, 10.5 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|ameliab
------- Additional comments from [email protected] Sun Aug 29 21:36:24 +0000 2010 ------- When viewing the results of a query, any sort order created in the query definition is applied "invisibly" -- it does not show up in the sort order dialog, you cannot remove it, and if you sort by any other column the new sort is added as a secondary sort (i.e., it often doesn't appear to do anything). The only sort that actually works as expected is if you reverse the original sort. Otherwise, it just appears to a user that the sort function doesn't work. It doesn't matter whether the "order by" function was added through the OpenOffice query design or by direct SQL to the underlying database (embedded HSQL in my case). The same problem does not exist with table views that contain "order by" statements -- you can sort the results normally when viewing data. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
