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

Allow a JQL query for a specific time span of the day, from a period of time

    XMLWordPrintable

Details

    • 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.

    Description

      Problem Definition

      At this moment, it is not possible to query events for a specific time span of the day, from a period of time.
      For example: Show me the issues created in the last 6 months that were created between 17h00 and 08h00.
      This won't be possible.

      Suggested Solution

      Allow a JQL query for a specific time span of the day, from a period of time.

      Why this is important

      It is relevant to managers/admins to understand which time of day is the most intense of issue creation, for example.

      Workaround 

      If needed, the admin can export the issues to a csv file and use the spread sheet editor (Office, OpenOffice, Numbers, etc) to perform the query.

      Attachments

        1. CSV exported.png
          CSV exported.png
          319 kB
        2. Export to CSV.png
          Export to CSV.png
          74 kB
        3. JQL nay.png
          JQL nay.png
          41 kB
        4. JQL yay.png
          JQL yay.png
          171 kB

        Issue Links

          Activity

            People

              Unassigned Unassigned
              rgebhardt@atlassian.com Ricardo Gebhardt (Inactive)
              Votes:
              11 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: