Using ScriptRunner, can I search for a specific time on a specific weekday?

[Sebastian Petruschat]

Hi there

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?

Best regards

Sebastian

[Liam Green · Accepted solution]

Hi @Sebastian Petruschat 

If you work it out in hours then you could use JQL.  E.g. 09:00 Tuesday would be startofWeek("+57h) and 06:00 Saturday would be startofWeek("+174h).

Hope that helps,

Regards, Liam

[Sebastian Petruschat]

Hi @Liam Green 

Thanks, this didn't even occur to me even though it is so simple...

Cheers,

Sebastian

[Liam Green]

Glad it helped!

[Juan José Marchal Gómez · Accepted solution]

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.

Best regards.

[Sebastian Petruschat]

Hi @Juan José Marchal Gómez 

This pointed me in the right direction, even though I used Liam's approach, this  will still be helpful in the future.

Thanks!

Cheers,

Sebastian