Search filter greater than in datatable

Question

I'm working with datatables and I need to use search() as follows:

let table = $('#datatable-table').DataTable();
$('#boton-filtrar').click(function (e) {
e.preventDefault();
table
  .column(8)
  .search('> 20') //Here is the cuestion!
  .draw();
  });

That is, create a search filter in column 8 that returns all numbers greater than 20.

Column number 8 contains numerical values.

20 is by way of example, since the value will be given by another input that is already prepared.

I have searched but I have not found anything.

Some help? Thank you.

the value you've assigned in `search` might be treated as `string` input by Datatables and that is why not be working, you should use either regular expression or other option mentioned in their API's — Rajender Verma, Oct 28 '18 at 17:47

score 0 · Answer 1 · answered Oct 28 '18 at 18:59

0

According to the documentation .search() is actually more of a filter which works with string comparison (either straight or using regular expressions). You want to filter/search based on a numerical comparison.

Have a look at how you can add this custom filtering function at https://datatables.net/examples/plug-ins/range_filtering.html

answered Oct 28 '18 at 18:59

Philip

2,888
2
24
36

But I do not have two values, I only have one, in the example: 20 – Jose Oct 28 '18 at 19:45
Then you can just adjust the example function to only use one – Philip Oct 28 '18 at 19:46

Search filter greater than in datatable

1 Answers1