I have a table with several fields, between them I have “check date”, “production date”, “article number”, I want to create a query to be run on an app in an embed table, this query will depend on variables from this app, the user can enter a range of check date and/or range of production date and / or single article, all those combination will show the result from the Tulip table on screen.
When I created this query for the date fields only, it worked great (althow you don’t have to possibility to filter a date by a range only before and after a date), this is because the date fields are always full.
When I added the possibility to filter by the article it didn’t work becuase this field can be empty if the user don’t want to filter by it.
So how can I combine those parameters in a single query ?
If I could change the use of query for the same embed table, I do that, but there is no possibility for that.