columnControl: Numeric search does not understand specified number format

lgt

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?

allan

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