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

XMLWordPrintable

    • 1

      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

       

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

              Created:
              Updated:
              Resolved: