Hello! I'm working with a self-install of metabase and trying to build my first dashboard. We have a dataset that has a definite hierarchy and have some custom SQL queries in postgresql that I'm trying to make use of. They work mostly great, with the exception of one. It requires me to pass 3 things to it: a UUID, start date, end date. I'm having trouble with creating variables for the start date & end date. If I just do this:
'select * from get_children_with_media_file_engagement([[CASE WHEN {{uuid}}='null' THEN null ELSE {{uuid}} END]], [[ {{from_date}} #]]CURRENT_DATE, [[ {{to_date}} #]]CURRENT_DATE);'
Everything works great but I can't replace the from_date & to_date with anything. If I set the type to "date", it passes extra info that causes the query to fail. If I set the type to text, whenever I try to change value through input box it fails. If I manually put in dates in the query itself it works fine like this:
'select * from get_children_with_media_file_engagement([[CASE WHEN {{uuid}}='null' THEN null ELSE {{uuid}} END]], '2023-11-03', '2023-11-08';'
but we want to be able to update the date range dynamically in the dashboard. Any thoughts or help? The UUID snippet in there works perfectly - it's just this date piece.