Smart value for project openSprint for automation rule

Question

Hi all,
I'm trying to make an automation rule for a Test Case issueType that when any update is made to it the automation rule will look up the current Open Sprint for the project and add a label with that Open Sprint name to the Test Case as a label. The problem is our Test Cases don't use the Sprint field in Jira even though they are under projects that use open sprints. I followed the thread here and came up with the following below:

{

"update": {

"labels": [{

"add": "{{#lookupIssues.first.sprint}}{{#if(equals(state,"active"))}}{{name}}{{/}}{{/}}"

}]

}

Unfortunately this did not work for me.
I know the Automation rule itself in general works because I swapped out

"add": "{{#lookupIssues.first.sprint}}{{#if(equals(state,"active"))}}{{name}}{{/}}{{/}}"

with

"add": "testLabel"
and that worked just fine when I triggered the rule.

Any other ideas of how I could alter this to get the label name I want?

Bill Sheboy · Answer

Hi @Sam Adams -- Welcome to the Atlassian Community!

As @Kalyan Sattaluri described with the linked thread, that smart value expression must first be put into a created variable, and then parsed to get the distinct values.  Please review the other thread to understand the technique.

Next, when using issue edit for a field, you may select the field or use advanced edit with JSON, but not both methods for the same field edit.  Please remove the Labels field from the dropdown, selected fields in the edit.

Finally, please remove the debug tokens when writing to the audit log: just write the smart value expression.  Debug is used when making a field edit with an expression, although I have rarely found it to be better / worse than just writing to the log.  The only valid use case I would consider is when a rule is approaching the 65 component limit, and so adding other audit log writes is not possible.

Kind regards,
Bill

Kalyan Sattaluri_iinm1n · Answer

@Sam Adams

You should have just started with rule screenshot so we did not have to go back and forth.

As you are not doing lookupIssues action in your rule and your trigger is "Issue updated" and is supplying the issue to the rule, so change your syntax to:

Log this, and assign to labels using advanced edit. Dont directly update labels field as Sprint name can have spaces and then you will end up with a mess.

Also, remove "Labels" from the dropdown selection aswell so as to not confuse Jira. You cannot have same field in advanced edit and the dropdown, it will throw an error.

Please confirm and if it works, else share screenshot of audit log. accept my answer in this thread if it works and also vote Bill solution on the other thread so that it surfaces in google search easily. Thanks!

Sam Adams_p1nfkb · Answer

Thank you both (@Kalyan Sattaluri @Walter Buggenhout ) for your replies and suggestions.

As requested here is a screen shot of my rule (updated now after your suggestions)

As you can see I added in @Kalyan Sattaluri new suggested string from @Bill Sheboy 's reply. This unfortunately did not work either :(  . 
Also as you can see I also added in the log suggestion at the end of my rule to see what value is being returned.....but when I go to the Log Results it just says

Log Action
Debug message
Log

@Walter Buggenhout , I did briefly try adding

{{#lookupIssues}}{{#sprint}}{{#if(equals(state,"active"))}}{{name}},{{/}}{{/}}{{/}}

to the Labels field directly as an Add but got an "Additional fields contains invalid field(s) in 'update' or 'fields' section: Custom Field Name" error (see below)

Any way thank you both again for your help. Open to suggestions or other things to try. thx