History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: SQL-19
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Bob Swift
Reporter: Arne Schirmacher
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Confluence SQL Plugin

Date column does not properly sort on click

Created: 13/May/07 02:20 AM   Updated: 18/Mar/08 08:56 AM
Component/s: None
Affects Version/s: 3.2.1
Fix Version/s: None

Time Tracking:
Not Specified

Environment: Confluence 2.5.1 standalone, Java 6, MySQL 5

Labels:


 Description  « Hide
For MySQL tables of type "date" the sorting function on click of the column header does not work. The order of rows changes but it appears not to be sorted by date.

Here is the macro text:

{sql:dataSource=pck|output=wiki}
select
PersKtoLetzterUmsatz as "Letzter Umsatz"
from
sPersKto
{sql}


 All   Comments   Work Log   Change History   FishEye   Crucible   Related Builds      Sort Order: Ascending order - Click to sort in descending order
Bob Swift - 13/May/07 09:10 AM
Please make sure your date format matches your PC format or use the advanced date sorting options documented on Common table capabilities

Bob Swift - 18/Mar/08 08:56 AM
Changed valued to affected release.