Hi,
We have simple filtering enabled on our grid. On number columns, we have decimal prices that display up to 4 decimal places. However, the filter field rounds off prices from 4 to 2 decimal places.
Is there some way to modify the filter field to allow it to filter 4, 5, n number of decimals?
Thanks!
CR
Hello Divya,
Upon doing above, the standard filters for number datatype is not available(like greater, less, >=).
can you help in setting 4 or n decimal places for filtering in columns.
Thanks.
The search worked when I changed the column dataType to double instead of decimal. maintaining the format.
can you give a JSFiddle example for that?
I have data with 4 decimals coming and i have mentioned "format:0.0000" in the column definition. still the simple filtering is getting rounded off to 2 decimals
Hello ,
To allow filter to perform filtering upto 4,5 and n number of decimal on particular column you have to allow column to accept that number of decimal to display.
In the grid as you have a column which display upto 4 decimal place and when you perform filtering on that column it rounds off prices from 4 to 2 decimal places. The same way you have to set that column for n number of decimal to perform that filtering.
Please let me know if I may provide you further assistance.
Sincerely, Divya Jain Associate Software Developer