- Goal:
I have a firebase query, which includes a timestamp check. I want to be able to run this query in my retool workflows as I do in my retool apps
I think the issue is retool has different parsing of parameter input in apps and workflows, I can put {{new Date()}} in a where clause in any app, it will throw error in GUI saying it expects string, but it will work fine. We can see the date object in the preview section for that input.
But in the workflow, it will show null instead of the date object when we put {{new Date()}}. As a result, we are getting an empty value.
It doesn't even run an imported query with a timestamp check, which is very weird.
I tried different values as the timestamp value, moment(), firebase Timestamp, etc. doesn't work, because the workflow query field parses every date object into null
This query works in any App and in the Query Library
But same query won't return any response in workflow
Even the query saved in the query library doesn't work when we try to call it from the workflow
