Hi,
I have a manual automation rule that creates a set of issues linked in unique ways between one another when an EPIC is created. I have over time, updated the rule where the latest version of the rule creates additional issues in the EPIC compared to the previous rule versions. I'm now trying to create a rule to check if there are missing issues in existing EPICs that used an older version of the rule, and if so, create the missing issues for the given EPIC to match what the current rule does.
I'm facing two problems
- I'm able to add 'For issues in EPIC' branch however, I cannot check in that branch if an issue is missing by checking for a particular summary and if so, create it; basically can't add nested branches
- I'm unable to use exact phrase checks for the summary of an issue in any of the SQL conditions; basically, the (\) escape character for quotes doesn't work as mentioned in your documentation for an advanced SQL