Summary: The message tool fails on evaluating the error message formula even if there are zero rows in the record set and the value is set to "before rows where 1=1". If there are no rows then the message tool should not evaluate the formula part of the error message at all.
Error:
Error: Message (80): Parse Error at char(38): Unknown variable "response_error_code"
Configuration to replicate:
Error Case:
Remediation:
Detailed Images:
Solved! Go to Solution.
@SeanAdams Thanks for bringing this to our attention. It would be a great help if you would submit defects to our customer support team, so that we can log them and escalate accordingly.
(Marking this as duplicate, since we'll log it through the defect progress rather than idea process.)
Thanks @SeanAdams and @RachelW.
We (Support) will create a case for this and reach out to Sean if we have further questions and/or updates.
+ @AndrewL
Splendid! Thanks @MargaritaW!
Hi All,
Just a note from the moderation team. We have moved this post over to the designer discussions area for greater visibility.
Thanks,
Been exchanging e-mails with @KevinW on this - and this is not an issue that can be resolved with a support ticket, since it's a baked in issue with the way the tools work.
Let me provide more colour - unfortunately I can't provide a sample workflow because it's company property, but I'll capture the essence.
What is short-circuit evaluation?
How does that apply here?
But surely this sounds logical?
So this is more of an idea than a support ticket - adding short-circuit evaluation to most of the tools will reduce run-time errors where you have a zero-rowset result from a dynamic tool - while at the same time having zero impact when there's a non-zero rowset - so it seems like a quick way to make Alteryx less prone to unnecessary run-time errors