tracker issue | What iT iS dESign studios

Title:

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:

Attachments:

Comments:

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

tracker issue : CF-4198334

Date Column not getting sorted in ColdFusion cfgrid 10