[#SQL-19] Date column does not properly sort on click

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

[ Permlink | « Hide ]

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

[ Permlink | « Hide ]

Bob Swift - 18/Mar/08 08:56 AM

Changed valued to affected release.