Black Lives Matter. Please consider donating to Black Girls Code today.

How do I filter a datatable with multiple conditions/criteia? - how to do && operands?

Lets say I have a datatable with a bunch of records. One of those columns is ‘temperature’ and I want to filter the datatable so it shows anything >100 and <200. How do I do this?

If I set it to >100, it shows me everything greater than 100, and <200 shows less than 200, but I can’t figure out what to put to show everything >100 and <200. I’ve tried >100 && <200 for the filter as well as >100 and <200 no results are displayed. Is there a certain syntax I need to use?

Hi @BigSteak4 in the example “Advanced filter usage” of, you can write a filter_query such as {lifeExp} ge 60 && {lifeExp} le 80 but I don’t know how to write such a query in a column filter…

Thank you, @Emmanuelle. I did know about that (I use that for conditional cell styling), but I wasn’t sure if there is a way to use multiple criteria in the native datatable filters. I suppose I can create an external control and use that to filter, although I wanted to avoid doing that if possible.