Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-23288 List of suggested JQL improvements
  3. JRACLOUD-23500

JQL query -- 'dates' clause similar to 'text' clause - e.g., search for date matches from any of many date fields

    XMLWordPrintable

Details

    • Sub-task
    • Resolution: Won't Do
    • None
    • None
    • Issue - Navigation

    Description

      I have a JIRA project that has 85 custom date fields, as well as the typical built-in date fields. (This project is used for tracking the development and publication of government regulations.)

      I am tasked with developing queries to answer questions about these dates. Examples:

      • find all the issues which have any date coming up in the next week
      • find all the issues which have no dates in the future

      It occurs to me that this is somewhat similar to the problem you solve with the 'text' clause, where the query "text ~ Exception" is a very succinct way to say "which issues have any text field(s) that contain(s) Exception".

      I can imagine some syntax like "dates >= 1w" could be a nice solution for example 1 above, if you were to develop a dates clause similar to the text clause.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              c31764eb97a4 Larry Talley
              Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: