Filtering on an numeric_filter with comma and dot

Suite and Optimus Suite 5
#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 ??

#6

it can only be achieved creating your own custom filter:
https://docs.dhtmlx.com/grid__filtering.html#redefiningdefaultfilterlogic