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

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

    XMLWordPrintable

Details

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

      Needed a JQL where the users can pull the details of all the created issues for multiple days/months between time slot1 and time slot2.

      For example: 

      Let's say there are 100 issues created in the year 2022 and they are 55 issues created around the time frame 12:00 A.M to 7:00 A.M and 45 cases for the other time frame.

      The user wants to list all 55 issues for the time frame 12:00 A.M to 7:00 A.M.

       

      Issue1 – created on 2 Jan 2022 at 8:00 A.M

      Issue2 – created on 3 Feb 2022 at 2:40 A.M

      Issue3 – created on 4 Feb 2022 at 2:00 P.M

      Issue4 – created on 10 Sep 2022 at 3:00 A.M

      Issue5 – created on 18Nov 2022 at 5:00 A.M


      Needs the below result.

      Issue2 – created on 3 Feb 2022 at 2:40 A.M

      Issue4 – created on 10 Sep 2022 at 3:00 A.M

      Issue5 – created on 18Nov 2022 at 5:00 A.M

       

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              b0f3ea76cadc Kashi Singh
              Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: