Complex Query - Multiple uses of the same field in different statuses

[Neta Knyazhansky Caspy]

Hi,

I'd like to create a complex query and need some assistance.

The query should include the field "Targeted End" that's now overdue, for all status, other then Completed.
And another use of the field "Targeted End" that are due in the next 8 days, and this one should be for all statuses.

Is it possible?
Can anyone please help with the syntax? 

Thanks!

[Bill Sheboy · Accepted solution]

Hi @Neta Knyazhansky Caspy 

First thing, I recommend taking this free online training from Atlassian as it shows how to answer such questions: https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

Next, using the issue search will help guide you through writing such queries.  To do this directly with JQL, please try something like this, substituting in your own project name:

project = myProjectName AND status != Completed AND "Targeted End" < startOfDay()

And you can adjust that for due in the next 8 days, inclusive:

project = myProjectName AND status != Completed AND "Targeted End" >= startOfDay() AND "Targeted End <= startOfDay(8d)

Kind regards,
Bill

[Neta Knyazhansky Caspy]

Thank you!