The condition in the database query does not work

[kfawcett]

I see. I haven't used the conditions much, so I'm not sure if it can do evaluations. @Teodor shows an example here.

Database Query Ignore Empty Values Conditions

Well Antony, the conditions are there exactly for this purpose. Add a condition for each group and it will be ignored if the condition is not met. So use the $_GET variable as a condition and it will be ignored if the GET variable returns no value ... [Screenshot_20] In my example if {{$_GET.country}} returns a value and {{$_GET.city}} does not - only the country filter will be applied. If {{$_GET.city}} also has a value, then country AND city will be applied.

Also see this.

How to filter a database query?

Ok so it’s not really hard to do this. On your page you need a text input and a select: [Screenshot 2021-05-25 at 10.37.37] I named them name and category but you can add whatever names you need. Your select needs an option without a value <option>Show all</option> [Screenshot 2021-05-25 at 10.38.19] Then in your server action create two GET variables for the filters, these GET vars will get the values from the two inputs on the page: [Screenshot 2021-05-25 at 10.38.42] And in the query…