Jira automation unable to use smart values in Lookup Issues

[Tomasz]

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

[David Blank · Accepted solution]

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?

[Tomasz]

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

[David Blank]

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

[Ralf Fehling]

Hey Tomasz,

Do quotation marks around the Smart Value expression help?

Regards Ralf

Edit: I misunderstood the question. I agree David.

[Tomasz]

Unfortunately no,

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

[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

[Tomasz]

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