I'm working with v0.40.3.1 on a Postgresql database, writing SQL queries and saving them to dashboards which use field filters.
When I create a field filter on the merchants.name
column and save it to a dashboard with a default value e.g. "Coffee Shop", the dashboard view works fine.
However, very often when I go back to edit that query, and then run it, it returns no results - because I have a line of code saying where {{merchant_name}}
, and the default value for {{merchant_name}} has been changed from "Coffee Shop" to "coffee shop" - removing the capitalisation. It's not that the default is still "Coffee Shop" and the query is now filtering for "coffee shop" - the default is changed.
This has been happening consistently over the last few months - and while I can fix it by changing the default value back to 'Coffee Shop', it's really annoying.