Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JRACLOUD-69417

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

    XMLWordPrintable

Details

    • 1
    • 13

    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature 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

          duplicates

          Suggestion - JRACLOUD-78314 JQL Filter to use a time range, irrespective of the date

          • Gathering Interest
          is duplicated by

          Suggestion - JRACLOUD-39636 Ability for JQL to search a specific time range for today only

          • Closed

          Suggestion - JRACLOUD-80815 Need JQL to fetch the list of created issues of all 365 days within the time frame between time1 and time2

          • Closed
          relates to

          Suggestion - JRASERVER-70201 Allow a JQL query for a specific time span of the day, from a period of time

          • Gathering Interest

          Activity

            People

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

              Dates

                Created:
                Updated: