-
Suggestion
-
Resolution: Won't Do
-
536
-
67
-
NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.
Hi everyone,
Thanks for voting and commenting on this issue. Your feedback is key to helping us understand how you use JIRA so we can continue improving your experience. We have reviewed this issue over the last few days; unfortunately we don't have any plans to support this in JIRA for the foreseeable future.
Please remember that jira.atlassian.com is one of many inputs for the JIRA roadmap. You can learn more about our process here.
I understand that our decision may be disappointing. Please don't hesitate to contact me if you have any questions.
Regards,
Dave Meyer
dmeyer@atlassian.com
Product Manager, JIRA Platform
In JQL, it's currently only possible to compare dates either with a single fixed date, or with a function such as now(), currentLogin(), or lastLogin(). It would be useful to be able to compare two date fields to one another, as in this seemingly simple query:
resolutiondate > duedate
This would allow filtering for issues that were resolved after their due date.
- is duplicated by
-
- Closed
-
- Closed
- is related to
-
- Future Consideration
- relates to
-
- Closed
-
- Closed
- mentioned in
-
Page Loading...
-
-
-
-
-
-
-
[JRACLOUD-20727] Add ability to compare date fields using JQL
Hi Customers,
We want to set expectations for the improvements that will come in the next 12-18 months, and this suggestion is not something we are considering in that timeframe.
Thank you for watching, voting, and commenting on this issue.
Eduardo | Atlassian Support Team
All comments
Hi Customers,
We want to set expectations for the improvements that will come in the next 12-18 months, and this suggestion is not something we are considering in that timeframe.
Thank you for watching, voting, and commenting on this issue.
Eduardo | Atlassian Support Team
It’s been since March 23, 2010, last update January 4, 2016, and now it’s September 27, 2024—it’s time to move forward with this!
It's an essential feature in project management and basic analysis ..
dmeyer do we have any update on this? It has been close to a decade since you commented on this issue. Are there any plans to implement date comparisons in JQL?
is there any update on this issue yet - it's ridiculous that something that should be simple and an automatic function in project management is not yet available. We have migrated to cloud and were using the issue function feature on server, but now we are unable to report on tasks completed past due because the cloud has no capability.
We have build an app able to compare dates.
Disclaimer: not for the exact requirement as this is SQL and not JQL strictly. However, it supports JQL too to search for issues and then compare dates on the results with SQL
As this issue is older than 10 years with no resolution yet, it might help some of you.
This is an essential function especially when issues have no indication when they are overdue like changing color of issue or auto triggered update to intimate managers without third party ad-ons. Date comparison in scheduled flows will simplify the task and is an essential feature.It will be helpful if available. Thank you!
Please reconsider...