tracker issue : CF-4198334

select a category, or use search below
(searches all categories and all time range)

Date Column not getting sorted in ColdFusion cfgrid 10

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce

Reporter/Name(from Bugbase): Girish Kattil / Girish Kattil ()

Created: 02/12/2017

Components: Language, CF Component

Versions: 10.0

Failure Type: Others

Found In Build/Fixed In Build: Cold Fusion 10 /

Priority/Frequency: Normal /

Locale/System: / Windows 10 64 bit

Vote Count: 0

Problem Description: Hi, We have a cfgrid populated from a database with date columns which is having the property mask="M/d/y" and type="date" .When we sort these colums they are getting sorted in string format instead of date format

Actual Result:

Expected Result:

Any Workarounds:



Girish, I am unable to observe the issue with the following test code on ColdFusion Server 10,0,22,300783 and CF2016u3: Clicking on Sort asc/desc on "col4" header sorts the rows chronologically and not based on the alphabetical order of the month name in the rows. Pls share a test case with which you can observe the issue. <cfscript> _qry = queryNew("key_col,title,body,category,date","Double, VarChar, VarChar, VarChar,date"); queryAddRow(_qry, {key_col:"1.1191919",title:"world history vol 1", body:"b1", category:"history", date:"27/07/1978"}); queryAddRow(_qry, {key_col:"433.3001",title:"popular science", body:"b2", category:"science", date:"02/12/1997"}); queryAddRow(_qry, {key_col:"4.001", title:"modern architecture ", body:"b3", category:"art", date:"19/04/1910"}); writeDump(_qry); </cfscript> <cfform name="grdform" id="grdform"> <cfgrid format="html" name="grid01" width="400" height="200" query=_qry> <cfgridcolumn name="key_col" display="true" header="key_col" type="numeric"> <cfgridcolumn name="title" display="true" header="col2"> <cfgridcolumn name="body" display="true" header="col3"> <cfgridcolumn name="date" display="true" mask="M/d/Y" header="col4"> </cfgrid> </cfform>
Comment by Piyush K.
1188 | March 03, 2017 08:52:16 AM GMT
Girish, Can you pls. share the info requested in my previous comment.
Comment by Piyush K.
1189 | August 07, 2017 08:54:12 AM GMT
closing this as the issue is not reproducible. can take this up if more information is made available.
Comment by Piyush K.
1190 | August 10, 2017 01:13:14 PM GMT