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

Getting 'Field 'End Date' does not exist or you do not have permission to view it.

Vijay Kumar_ln3ogr

I am trying to create an automaton. The automation is that JIRA should be able to send a email notification to some of the project team members just two days before the end date of the sprint, saying these are the issues currently are NOT in DONE status. As part of this automation, where I need to provide JQL, and i am providing below JQL,
sprint in openSprints() AND "End Date"<= startOfDay(2d)
But while validating query, its giving me below error,

I tried to fix this error by providing end date field is following ways,
1) "End Date"
2) EndDate
3) endDate

None of this helped. Now i started getting the doubt that, my JQL itself is correct or not.
Can somebody help me on this please?

Accepted answers

All comments

Bill Sheboy

Hi @Vijay Kumar -- Welcome to the Atlassian Community!

The sprint's endDate attribute is not available with built-in JQL, and so may not be used in a query.

If your sprints are occurring on a consistent cadence you could try a Scheduled Trigger rule, selecting the starting point and frequency to align with your sprint's time frame. This may be the simplest approach (other than the team just reminding itself at the daily standup).

Another alternative is to run your rule every day, gather an example issue in the openSprints() and then check the smart value for the endDate to determine if it is within 2 days. https://support.atlassian.com/cloud-automation/docs/jira-smart-values-development/#--sprint--

Kind regards,
Bill

Semih Tolga Yazici_f29rg0

Hey Vijay,

I will try to help you in 2 different ways.

First you can create a scheduled automation rule.
And add a JQL condition like that: sprint in openSprints() AND statusCategory != Done
Add advance compare condition
{{sprint.endDate.diff(now).days}} (if this does not work find a smart value in a same purpose)
Equals 2
Send email notification.

Secondly and easier way,
You can just use the JQL that you're created and Add a subscription for it according to relevant project members and send daily emails for the all open issues.
To be able to do that just save the JQL as filter and Add subscription.

Vijay Kumar_ln3ogr

Thanks Bill, for the help. Will explore this approach.

Vijay Kumar_ln3ogr

Thanks Semih, will work on the approach suggested and keep you posted.

Semih Tolga Yazici_f29rg0

You're welcome, btw statusCategory != Done will exclude all the green status issues.

Vijay Kumar_ln3ogr

Hi Semih,

Thank you so much again for all the inputs. I was able to successfully create the automation as per your instructions. I want to understand each step of the process. So, hope you don't mind answering me following questions.
1) openSprints() AND statusCategory != Done
The above JQL, basically creates the list of issues from active sprint, which does not meet the criteria of done.
Also, you mentioned about green status issues. I am not sure, which of the issues are called 'green status issues'. I am just curious to know.
2) Advance compare condition
{{sprint.endDate.diff(now).days}}
My understanding is that, this condition will first find the sprint end date, current date and find the difference which should be equal to 2. Once it meets this condition, it will trigger the email with a list of all the issues in the email body in HTML format.

Please let me know.

Welcome!

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

Quick Links

Find more posts tagged with

jira

jql

automation

jira-automation