JQL help

Question

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 · Answer

Yes, it will.

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

BR, Olga

Sibiya Abraham · Answer

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 · Answer

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