JQL help

[Sibiya Abraham]

Hi,

can someone help with a JQL query please?

i have an automation trigger in Jira, where i would like it to be triggered if the due date of an issue is either tomorrow or on current day at 3PM. i figured out the time part but cannot get the JQL right for the day part.

[Olga Videc]

Hello Sibiya,

JQL 

Tomorrow due < endOfDay("+1")

Today till 3PM due <= startOfDay(15h) 

It will find all issue that is due, also it will find an issue that was due yesterday if you need specific issues that are due specifically tomorrow

Specifically tomorrow due <= endOfDay("+1") AND due > endOfDay()

Today till 3 PM due >= startOfDay() AND due <= startOfDay(15h)

BR, Olga

[Sibiya Abraham]

thank you, would it work if i want the trigger to look for any issues that has a due date of tomorrow? as in, i would be running the rule today and i want it to look for issues having a due date of tomorrow.

[Olga Videc]

Yes, it will.

You can check it easily just run the JQL in your issue search and check the results.

BR, Olga