Searchbuilder filter not working for numeric values
Searchbuilder filter not working for numeric values
puffster
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
This discussion has been closed.
Answers
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
Does the https://jsfiddle.net/BigSexy/gkyoju4x/16/
not count as a test case?
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
Much appreciated for the quick answer and glad it wasn't something silly I was doing!! Thanks for the info.