Title:
CFGrid: Cell value gets cleared, when the cell with date mask is selected on CF11
| View in TrackerStatus/Resolution/Reason: Closed/Fixed/
Reporter/Name(from Bugbase): / Japanese Team (Anit Kumar Panda)
Created: 02/03/2016
Components: AJAX, UI Components
Versions: 11.0
Failure Type: Non Functioning
Found In Build/Fixed In Build: 296330 /
Priority/Frequency: Major / Some users will encounter
Locale/System: English / Mac 10 All,Win XP All
Vote Count: 0
Problem: CFGrid: Cell value gets cleared, when the cell with date mask is selected on CF11
Method:Run the code and click on the date cell.
<cfscript>
variables.myQuery2 = queryNew("id,myDate");
queryAddRow(variables.myQuery2,2);
querySetCell(variables.myQuery2,"id",1,1);
querySetCell(variables.myQuery2,"myDate","09/02/2005",1);
querySetCell(variables.myQuery2,"id",2,2);
querySetCell(variables.myQuery2,"myDate","09/03/2005",2);
</cfscript>
<cfform name="myTest">
<cfgrid
name="myGrid2"
format="html"
selectmode="edit"
autowidth="true"
preservepageonsort="true"
striperows="yes"
query="variables.myQuery2"
width="360"
title="Case 1: mask=m/d/y">
<cfgridcolumn name="id">
<cfgridcolumn name="myDate" mask="m/d/Y" type="Date">
</cfgrid>
</cfform>
<cfscript>
variables.myQuery1 = queryNew("id,myDate");
queryAddRow(variables.myQuery1,2);
querySetCell(variables.myQuery1,"id",1,1);
querySetCell(variables.myQuery1,"myDate","2005/09/02",1);
querySetCell(variables.myQuery1,"id",2,2);
querySetCell(variables.myQuery1,"myDate","2005/09/03",2);
</cfscript>
<cfform name="myTest">
<cfgrid
name="myGrid1"
format="html"
selectmode="edit"
autowidth="true"
preservepageonsort="true"
striperows="yes"
query="variables.myQuery1"
width="360"
title="Case 2: mask=Y/m/d"
>
<cfgridcolumn name="id">
<cfgridcolumn name="myDate" mask="Y/m/d" type="Date">
</cfgrid>
</cfform>
<cfscript>
variables.myQuery3 = queryNew("id,myDate");
queryAddRow(variables.myQuery3,2);
querySetCell(variables.myQuery3,"id",1,1);
querySetCell(variables.myQuery3,"myDate","2005/09/02",1);
querySetCell(variables.myQuery3,"id",2,2);
querySetCell(variables.myQuery3,"myDate","2005/09/03",2);
</cfscript>
<cfform name="myTest">
<cfgrid
name="myGrid3"
format="html"
selectmode="edit"
autowidth="true"
preservepageonsort="true"
striperows="yes"
query="variables.myQuery3"
width="360"
title="Case 3: mask=y/d/m"
>
<cfgridcolumn name="id">
<cfgridcolumn name="myDate" mask="Y/d/m" type="Date">
</cfgrid>
</cfform>
Result: Only "Case 1" will show the correct date. for rest of the cases, the cell value is cleared, when clicked.
Expected: It should open the calendar with specified date.
Additional Info:- Since the default format is m/d/y for ext.js, it works. Please see the " mask" info at https://helpx.adobe.com/coldfusion/cfml-reference/coldfusion-tags/tags-g-h/cfgridcolumn.html
Browser debugger shows the below errors:-
Uncaught TypeError: Cannot read property 'getDayOfYear' of null
$G.Actions.afterEdit @ cfgrid.js:797
Ext.define.fire @ ext-all.js:18
continueFireEvent @ ext-all.js:18
fireEvent @ ext-all.js:18
(anonymous function) @ ext-all.js:18
Ext.define.fire @ ext-all.js:18
continueFireEvent @ ext-all.js:18
fireEvent @ ext-all.js:18
Ext.define.onEditComplete @ ext-all.js:18
Ext.define.fire @ ext-all.js:18
continueFireEvent @ ext-all.js:18
fireEvent @ ext-all.js:18
Ext.define.completeEdit @ ext-all.js:18
Ext.define.onFieldBlur @ ext-all.js:18
b @ ext-all.js:18
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 4113472
External Customer Info:
External Company: Katsuhito Oinuma
External Customer Name: Japanese Team
External Customer Email: mmsupport@samuraiz.co.jpAttachments:
Comments: