Scheduled Automations JQL Not Working With Double Quotes

[Tom N Scoggin Jr]

I've successfully created a couple scheduled automations with (Project = "Project Name" AND Status = Verify) but when I change the Status to (Status = "To Do") the system validates the JQL but it will not publish it. The system just spins and never publishes. 

I've tried this several ways and it always gives me trouble when using any "" in the JQL.

We are using Jira Software for Data Center

[Jasen Sparacino · Accepted solution]

We had to make a plugin and mod the templates to get the info we wanted.

[Danilo Conrad]

Hi Jasen,

It seems you would like something similar to what was asked on the related post below:

https://answers.atlassian.com/questions/45630/add-reason-for-email-to-jira-notification

Unfortunately, this is not possible in JIRA by default, and requires some kind of customization (either by modifying the velocity templates or via code) to be achieved.

Cheers,

Danilo

[Teck-En]

It's not possible without editing the velocity mail template used by JIRA: https://developer.atlassian.com/display/JIRADEV/Adding+Custom+Fields+to+Email

[Jasen Sparacino]

I get that part but how do I get the template to figure out what your role is? For instance, if my role in the issue was "watcher" how do I get that to show in the email as "Your Role: Watcher" as oppsed to say a custom field value like, Owner. In which case it would say "Your Role: Owner" or "Your Role: Lead" which Lead would be another custom field that we have.