Grid Filter Incorrectly Assumes Date

[tapickensMember]

Hello,

I am having an issue where, when filtering on a column that is an 8-character string, the grid assumes the filtertype to be a ‘datefilter’ if all of the characters are numeric. For example, ‘00270027’. I have traced into the source, and it looks like the filter is using the first record entry (in the _getcolumntypebydatafield function) and attempting to determine what data type it is, and it sees that the string ‘00270027’ can be parsed as a date and assumes that is what it is. Is there a way to explicitly tell the filter what data type to use or some other way to work around this? Thanks.

[Peter StoevKeymaster]

Hi tapickens,

I suppose you missed to add the type of your data fields. I suggest you to take a look at the Grid’s Help Topics and especially this one: jquery-grid-datasources.htm.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[tapickensMember]

Thanks for the response. You’re right – in fact I was not defining the ‘datafields’ property at all for the source so I guess it was trying to figure it out by itself. Thanks.

[Author]

Posts