Toad World® Forums

Toad for DB2 v5.6.2356 -- Custom Filter Popup on Result Set Doesn't Sort Date Columns Correctly


#1

When using the custom filter button for a date column on a result set in the Editor the popup display does not sort date values in chronological order but instead sorts data values in textual order.

Example:

Currently sorts as 11/1/2013, 11/11/2013, 11/2/2013. Should sort as 11/1/2013, 11/2/2013, 11/11/2013.


#2

Hi Richard,

The popup for basic filters treats non-built-in data types as strings.

Regards,

Adam


#3

Hi Adam, hopefully we are talking about the same thing. I just checked this feature in 5.2 and it works fine. The filter button I refer to is the symbol in the upper right corner of any column header in the result set. The data type for the column with the issue is a date data type.

Richard


#4

Sorry Richard I didn’t test far back enough. You’re exactly right. Date values used to be sorted in date order and they’re not any more.

Thanks for reporting this and sticking with it. I appreciate it.

Adam


#5

I opened issue TDB-234 with development to track the resolution of this problem.


#6

Thanks Adam.


#7

Edit: In the post header changed build from 2256 to 2356.