Add if statement from Retool in SQL query

Queries and Resources
1

Hi everyone,

I have a normal "SELECT" MYSQL-Query in a Resource. If a date field in a form is filled, I want to run the query but add an additional "AND value_from > {{date.data}}. That's because I only want to filter for the dates if a date is filled in the form. Otherwise, I want to show all records without date filtering. Info: default value in the date vield in the database is NULL.

How can this be done?
Thanks for your help.

Best,
Thomas

2

Use:

3

Hey @thim-jbm! It sounds like you might be looking for something like this:

Let me know if you have any questions!

https://community.retool.com/t/sql-cheatsheet-best-practices-for-different-flavors-of-sql-syntax/23902