Search builder conditions don't work on my date and décimal column

drill

Hi guy ! My search builder does not make the conditions on my date (YYYY-MM-DD) and numeric columns (decimal number with point as decimal separator) I have the impression that it identifies them as characters, because it rather applies character conditions.

sandy

Hi @drill ,

Try using the nightly builds and setting the columns.searchBuilderType option.

If that doesn't work, as noted in the forum rules, please post a link to a running test case showing the issue so we can offer some help. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Thanks,
Sandy

drill

Hi @sandy thanks the columns.searchBuilderType option help me. the condition with the date work well.

But currently the condition limits the date between the years 1996 to 2046. I cannot go below 1996 year

colin

You need to set the yearRange for the DataTime plugin for that - see example here.

Colin