columnControl: Numeric search does not understand specified number format
columnControl: Numeric search does not understand specified number format
lgt
Posts: 1Questions: 1Answers: 0
We are facing an issue with the columnControl search functionality for numeric values (gt, lt, etc.).
- We display numeric values with ',' as decimal instead of '.' and a suffix
- We achive this by passing
DataTable.render.number('.', ',', 1, '', ' %')
Expected behaviour:
Searching gt with ',' works. For example 2,6 % is displayed and should be searchable with gt 2,5.
Observed behaviour:
Searching with ',' does not work. Only searches using '.' work.
I assume this does not work because the parameter is directly parsed to a number in the search without regards to the format.
We also set the language.decimal option, just in case, but still no success.
Is there a way to match the search's decimal character with the number format's?
Answers
Hi,
Thanks for your post and apologies for the delayed reply. Are you able to link to a test case showing the issue so I can take a look at the problem please? I need to know the full configuration of the table (e.g. server-side processing mode is a key one).
Allan