I know that I can use
project = ABC AND ((created > startOfWeek("+2d") AND created < startOfWeek("+7d")))
to look for issues created between Tuesday and Saturday. But what I need is to narrow the range down to issues created between Tuesday 09:00 and Saturday 06:00.
I know JQL can't do it. Can I use ScriptRunner's JQL functions (or a custom function) to do this?
Hello @Sebastian Petruschat ,
Yes, with ScriptRunner this can be done.
You can create a function with Scriptrunner that the params will be date and inside the code, set the time that you want. WIth the option "JQL Functions".
Later on, when the Function is developed you can use "IssueFunctionIn" of Scriptrunner in all the JQL that you want to use.
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events