Searchbuilder filter not working for numeric values

puffster

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...

colin

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

puffster

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

not count as a test case?

colin

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

puffster

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