Hello community.
I wrote SQL query for On timeout – Insert condition (SQL). My query is returning true value, but action is not working. See figure for details. Any idea what could be the problem? Thank you.
Hello community.
I wrote SQL query for On timeout – Insert condition (SQL). My query is returning true value, but action is not working. See figure for details. Any idea what could be the problem? Thank you.
Hi Ondrej,
whenever I have to return "true" in a SQL statement I return 1. That's safer in most cases.
Quote from the blue info icon:
"
If query returns 1 or 'true' timeout will be associated with instance. Otherwise timeout will be ignored.
"
It's probably an problem with the spelling of your TRUE. :)
Best regaards,
Daniel