Searchbuilder filter not working for numeric values

Searchbuilder filter not working for numeric values

puffsterpuffster Posts: 61Questions: 22Answers: 0

https://jsfiddle.net/BigSexy/gkyoju4x/16/

        var dt = $('#ccr2018').DataTable({
          paging: false,
            dom: "<'row'<'col-6'Q><'col-6'f>" +
                "<'row'<'col-12'tr>>",
          searchBuilder: {
            columns: [
              0, 1
            ],
          },
          language: {
            searchBuilder: {
              add: 'Add Filter',
              clearAll: 'Reset',
              data: 'Column',
              title: {
                0: 'Filters',
                _: 'Filters (%d)'
              },
            }
          },
          columns: [{ //0
              className: "detailRow text-left",
              type: "string"
            },
            { //9
              type: "html-num",
            },
          ],
        });

My SearchBuilder returns "No Records Found" if I do a search on any numeric column in my table. I've created a simplified version of my table, if you Add filter for ACT Score, Condition = Less Than Equal To, Value = 18, it will return no rows. It does this for any of the numeric filtering -- between, greater than, etc. Curiously enough though, if you select "Equals" it returns all the values for you to select one...

This question has an accepted answers - jump to answer

Answers

  • colincolin Posts: 15,118Questions: 1Answers: 2,583

    It's working here with the Age column, so it's going to be something specific to your setup. We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. 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.

    Cheers,

    Colin

  • puffsterpuffster Posts: 61Questions: 22Answers: 0

    Does the https://jsfiddle.net/BigSexy/gkyoju4x/16/

    not count as a test case?

  • colincolin Posts: 15,118Questions: 1Answers: 2,583
    Answer ✓

    Ah yep, it does, sorry, I missed that. That problem was resolved recently, see your example updated with the nightly builds: https://jsfiddle.net/bj8p6qr4/

    We'll probably be releasing that in the next week or two in the next SearchBuilder release, but you could just grab the nightly releases here in the meantime,

    Colin

  • puffsterpuffster Posts: 61Questions: 22Answers: 0

    Much appreciated for the quick answer and glad it wasn't something silly I was doing!! Thanks for the info.

This discussion has been closed.