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

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

drilldrill Posts: 12Questions: 5Answers: 0

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.

This question has an accepted answers - jump to answer

Answers

  • sandysandy Posts: 913Questions: 0Answers: 236

    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

  • drilldrill Posts: 12Questions: 5Answers: 0

    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

  • colincolin Posts: 15,177Questions: 1Answers: 2,590
    Answer ✓

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

    Colin

Sign In or Register to comment.