Query for date

How to get all issues for a date field which is above the end of current week?

1 answer

0 votes

Answer accepted

JQL goes like this, (In this I have checked for a due date field, you may replace the field with the date field you have customized)

project = projectKey AND due >= endOfWeek()

Thanks,
Pramodh

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Thank you so much Pramod. it works. would you happen to know how i can put a time period for the dates as well?

example - to find out if list of issues for a date field which starts from end of current weeks and falls in 4 upcoming weeks and 8 up coming weeks?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

We would have to specify that with the number

For example, for issues due by end of 4 weeks, the JQL is

project = projectKey AND due >= endOfWeek(+4)

And for 8 weeks, JQL is

project = projectKey AND due >= endOfWeek("+8")

Thanks,
Pramodh

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

FYI,

We have to submit the number in quotes.

project = projectKey AND due >= endOfWeek("+4")

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.