Search Records Is Today condition is broken
Hi, when using the 'Search Records' action and the 'Is Today' condition, the output only shows the date of creating or modifying the workflow.
Using my Google Chat integration as an example.
Trigger - Schedule - Daily -> Action - Search Records - Object People - Conditions Where Follow Up Date (Custom field in people data model just date selection) Is Today - Limit 30 -> Action - Iterator - All People -> Loop -> HTTP Request - POST - Raw JSON { "text": "iterator.firstname iteratior.lastname iterator.email" }
Seems simple, but every day when the workflow is automatically run, it will output data from the 26th (when the workflow was created). Sometimes it will output correct data on a test run, but that's normally after updating the workflow (which counts as modifying, so the date updates to that moment)
4 Replies
CC: @Lucas @thomast
Ok so it seems that each run takes the day of the last modification, I created an issue here so we can address your problem soon : https://github.com/twentyhq/twenty/issues/15626
GitHub
Relative date filter in a workflow step is not working as expected ...
The IS_TODAY relative date filter should take the present day at the time of the execution of the workflow. But a user reported that it takes the day that corresponds to the last time the workflow ...
Thanks! One note though
"Triggering the workflow manually seems to work though"
It may seem like it works if you are doing all your testing in one day
but if you create your work flow and then run a manual test the next day with out making any changes it will still output the data from the previous day rather than the current date
Ah that's important indeed, so the bug is consistent at least ! It will help us.