nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Tom N Scoggin Jr

Answer/Workaround

Project = "Project Name" AND Status was not "Done" And Status was not "Cancelled"

This is the only way I was able to make it work. "Was not" seems to work with everything, even with statuses like "In Progress" which has a space in it. I don't know what's going on with "in" or "not in" but any time you use some of the other validators it does not like double quote with something in it with a space like "In Progress".

Maybe this will help someone else.

All comments

John Funk

Hi Tom,

Are you tying it from scratch or are you pasting it in from somewhere? If pasting, try typing it directly and see if that helps.

Tom N Scoggin Jr

No. I typed it in and if I change "To Do" to a single word like Verify it works every time.

John Funk

Strange. I would try putting it in the advanced query, execute the search from there, then copy and paste the entire query into the Automation section and try the verify then.

Tom N Scoggin Jr

I've done that. The JQL is fine in the filters but not when you do a " " in the Scheduled automation.

Tom N Scoggin Jr

Answer/Workaround

Project = "Project Name" AND Status was not "Done" And Status was not "Cancelled"

Maybe this will help someone else.

John Funk

Glad you figured out a workaround for it.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

automation