Does not filter on the formatted price

[mscodigno]

Hello, the price field comes from the database in the format '#. ###, 00'. I cannot use the filtering feature in this column. What should I do?

https://jsfiddle.net/zekeriyaerogluu/kqmzv45u/31/

[paramvir]

Formatted values can be converted back to numbers with pq.deFormatNumber method.

Code: [Select]

    var dataModel = {
      data: data.map(function(rd){     
        rd.unitePrice = pq.deFormatNumber(rd.unitePrice, "#.###,00");
        return rd;
      })
    };

https://jsfiddle.net/eu5jkphm/

[mscodigno]

1. I want it to appear formatted in the edit box as well. Can i do that?

2. How can I do for remote data?

[paramvir]

1. No

2. Please use dataModel.getData callback.