Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-20727

Add ability to compare date fields using JQL

XMLWordPrintable

    • 199
    • 23
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

      NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? See the corresponding suggestion.

      Atlassian Update – 10 September 2018

      Hi everyone,

      Thanks for your interest in this issue. This suggestion is considered a potential addition to our longer-term roadmap. We'll typically review this request in about 12 months time, at which point we’ll consider whether we need to alter its status.

      For the nearest future we've decided to prioritize other areas of the Jira Server roadmap, including the top-voted suggestions:

      In the recent Jira Server releases we have also shipped some highly-voted features and improvements, including:

      • Filters and dashboards collaborative editing
      • Selectable delimiters in CSV export 
      • Microsoft SQL Server 2016 support 
      • iPv6 support
      • Faster Kanban boards
      • Refreshed projects and custom fields management pages in the admin's section 

      We hope that you appreciate our candid and transparent communication. You can learn more about our approach to highly voted server suggestions here.

      To learn more on how you suggestions are reviewed, see our updated workflow for server feature suggestions.

      Kind regards,
      Jira Server Product Management

      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.

              Unassigned Unassigned
              aatkins TonyA
              Votes:
              644 Vote for this issue
              Watchers:
              305 Start watching this issue

                Created:
                Updated: