Can't get Spint ID and end date using lookupissues in JIRA automation

Kavita Patil_je8gi8

Hi All,

I want to automatically send an email to users a day before the sprint ends that they need to close the JIRAs. I have created JIRA automation to lookup issues with JQL "spint in openSprints() AND status != Done AND project = "my project name". After that when I create a compare condition, with 

 

({{lookupIssues.first.sprint.endDate.jiraDate}} equals {{now.plusDays(1).jiraDate}}) and send email based on this condition, email is not sent. If I try to just skip the comparison and send email with 

 

({{lookupIssues.first.sprint.endDate.jiraDate}} and 

 

({{lookupIssues.first.sprint.id}} in the subject, I do not get any values. 

How can I get these values if my context is not the triggers, Sprint Created, Sprint Completed or Sprint Started?

Trudy P Claspill

Hello @Kavita Patil 

Welcome to the Atlassian community.

Whenever you ask for help with an Automation Rule it will help us to help you if you provide:

1. screen images that show your entire rule,
2. screen images showing the details of the step(s) that aren't generating the result you expect
3. screen images showing the Audit Log details for the rule execution
4. screen images showing the relevant data in an image that is part of the rule execution

Can you provide a screen image that shows the content of the Sprint field for one of the issues that is returned in the Lookup Issues results? What I am hoping to discover is if the issue(s) have been associated to multiple sprints. If they were associated to a sprint in the past, and were not completed in that sprint and not removed from that sprint, then the Sprint field will have multiple values. Trying to get the sprint date information for a specific sprint within the Sprint field is then more complex.