Hi All,
Is there a dynamic JQL to fetch tickets created post 5PM and before 8am the next day for an entire month?
Currently we are using
created >= "2024-11-12 17:00" AND created <= "2024-11-13 08:00" AND project = "ABCD" AND type = Task
and it only gives result for particular dates mentioned in JQL.
We need the data for an entire month. For example, Issues created on 1st Nov after 5pm and on 2nd Nov before 8 am. Then for 2nd Nov after 5pm and 3rd Nov before 8 am and so on....
Note - We are not using any plugins that provides additional JQL functions.
Unfortunately, JQL doesn’t support recurring date functions, so you have to manually list each day. Alternatively, you could use a Jira automation rule or script to simplify and automate this if you need it regularly.
(created >= "2024-10-01 17:00" AND created <= "2024-10-02 08:00")
OR (created >= "2024-10-02 17:00" AND created <= "2024-10-03 08:00")
OR (created >= "2024-10-03 17:00" AND created <= "2024-10-04 08:00")
OR (created >= "2024-10-04 17:00" AND created <= "2024-10-05 08:00")
OR ...
Hi @Dave Mathijs ,
Thanks for confirming this! I suspected that JQL doesn't support recurring date functions, but I needed someone to verify it. I appreciate your input on this.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In addition to the suggestions from @Dave Mathijs ...
How often do you need to perform a query like this and how much money / effort are you willing to invest in it?
Kind regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Bill Sheboy ,
Thanks for your input!
We want to avoid any additional costs, so we'll try your approach of using lookup and filtering smart values, along with simple (though unfortunately long) JQL as suggested by Dave.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.