Hi, I'm unable to use smart values in Jira automation Lookup issues step. My flow is: 1. When sprint completed 2. Lookup issues 3. Send an email I can use smart values in the email but when I try to use it in JQL query (project= AND sprint={{sprint.id}}) I get "Error in the JQL Query: The character '{' is reserved JQL character..." Also when I put {{sprint.id}} validate query button becomes grayed out. How can I use smart value in jql??? BR, Tomasz

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; } } }

Jira automation unable to use smart values in Lookup Issues

Tomasz_1rc11q

Hi,

I'm unable to use smart values in Jira automation Lookup issues step.

My flow is:

1. When sprint completed

2. Lookup issues

3. Send an email

I can use smart values in the email but when I try to use it in JQL query (project=<Name_of_the_prohect> AND sprint={{sprint.id}})
I get "Error in the JQL Query: The character '{' is reserved JQL character..."

Also when I put {{sprint.id}} validate query button becomes grayed out.

How can I use smart value in jql???

BR,

Tomasz

Screenshot 2023-09-13 at 18.48.25.png Screenshot 2023-09-13 at 18.51.27.png

Accepted answers

David Blank

Hi @Tomasz and welcome to the Atlassian Community!

You are able to use smart values in JQL in Automation but you cannot use Smart Values in search or validate your JQL query containing a smart value because it does not have a value until the automation is triggered by an issue. The Smart Value is blank until the point it is populated by an issue (or sprint) that triggers the automation.

What happens when you run the automation like you have it? Can you show us the audit logs after you complete a sprint to see how it is evaluating the sprint?

All comments

Carmen Odimba

Hi @Tomasz ,

to find out the right JQL, you can search for the sprint by its name in the issues search bar. The sprint name will be converted to an ID once you're finished typing the sprint name.

Copy the filter and paste it in your automation step.

Best regards

Carmen

Ralf Fehling

Hey Tomasz,

Do quotation marks around the Smart Value expression help?

Regards Ralf

Edit: I misunderstood the question. I agree David.

David Blank

Hi @Tomasz and welcome to the Atlassian Community!

What happens when you run the automation like you have it? Can you show us the audit logs after you complete a sprint to see how it is evaluating the sprint?

Tomasz_1rc11q

Unfortunately no,

"Sprint with name '{{sprint.id}}' does not exist or you do not have permission to view it."

Tomasz_1rc11q

I want to have automation set up on each completed sprint (email send with some data) I can't insert the sprint name/id explicitly

Tomasz_1rc11q

Hi David,
I run the automation and the search worked perfectly!!!
I've been struggling with it for quite some time
Thank you very much!

David Blank

That's great news @Tomasz ! I'm happy to help!

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud