Filtering on an numeric_filter with comma and dot


#1

Hi,

I have a dhtmlxgrid with a numeric_filter on one column.
That column contains numeric values like “3.4”, “37.8”.
When I put a filter like “>3.3” it works.
I would like to know if it’s possible that the filter still works when i replace the dot with a comma, like “>3,3” (only in the filter, tha data still has values with dot).

Thanks in advance.


#2

Please, open dhtmlxgrid_filter.js
Find the function:
dhtmlXGridObject.prototype._in_header_numeric_filter=function(t,i){

and replace:
var v=this.value;
with:
var v=this.value.replace(",",".");


#3

Thanks for your solution.
Il will try it soon.


#4

Thanks!!!
I confirm…it worked!


#5

Can I make the numerical filter with several parameters?. por example <>100 & <>300 ??