What is the JQL for results within the next three days?

Deleted user January 5, 2020

Hi there,

We are using our servicedesk for a few weeks now. We implemented a custom field 'starting date' for issues to be worked on later. I can imagine someone forgetting about that date and there seems to be no solution to have a reminder. Therefore I wanted to create a custom queue that searches for issues that have a starting date within the next three days. I found that the JQL only supports now() or startOfDay() and several others. When messing with these operators I couldn't find one that works for me. I tried several things like 'starting date < (now() + 3)' or 'starting date < startOfDay(3d)', but that didn't get the right results. It gave some results, but those weren't the right ones (since I knew which issues should have appeared).

Any suggestions? Thanks!

1 answer

1 accepted

0 votes
Answer accepted
Johan Soetens _Dumblefy_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 5, 2020

Hi Tommy,

please try with startDate <= 3d

Deleted user January 5, 2020

Hi Johan,

Didn't think about this one, thanks a lot!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events