Identify workflow transitions that trigger an email notification

[Nicole Gosling]

Hello,

We are currently rewriting one of our Jira projects to streamline the process.  There are over 40 transitions in our current workflow (no judgement I just took over Jira Support :D) and I need to identify those that trigger an email notification.  Is there an easy way to do this via a SQL script or do I have to look through every transition?

Thanks in advance,

Nicole

[Fabian Lim · Accepted solution]

Hi @Nicole Gosling

You will have to go over each transition and look at the properties of each post-functions.  Based on your crazy workflow it shouldn't take more than 30 minutes :p 

Also check the jira automations to see if there are any email notifiactions being sent.  

Regards

[Nic Brough -Adaptavist- · Accepted solution]

@Fabian Lim 's answer is correct, but I wanted to address the "is there a SQL query" part: Yes, you can read the workflow from the database with SQL, but it is a huge block of xml, so you'll still have to read it for every transition, and look at the "event fired" post-function.  This is a lot slower than clicking through each transtition in the UI!

[Jon Chatwin]

OMG. I was the previous support person for this workflow. I just googled crazy workflow diagrams, and this was the top result. 

I did not create this and inherited it, and ran away. Poor Nicole. I'm sorry. If you ever have questions about it let me know. I can give all the background. 

[Fabian Lim]

lol

[Nicole Gosling]

Thanks Jon :)