Can any one explain below JQL

[seethamraju]

Hi Team, 

Can you please explain me below listed JQL.

project = ABCD AND issuetype in (Bug) AND NOT (status = Closed AND resolutiondate <= -5d) ORDER BY Priority DESC

Thanks,

Raju

[Matt Doar]

It finds Bugs in the project ABCD.

Then the second clause finds old closed issues

Then the NOT says show everything but that.

Drawing venn diagrams often helps me

[Cody Stevens]

It looks like its doing the following

• Looking only at issues in the ABCD project
• Looking only at issues that are in the Bug issue type
• Looking only at issues that are not in the closed status
• Looking only at issues that were not resolved in the last 5 days

Here's a deeper breakdown:

project = ABCD means its only looking at issues in the ABCD project

AND issuetype in (Bug) means its only looking for the bug issue type

AND NOT (status = Closed AND resolutiondate <= -5d) means its ignoring issues in the closed status and issues that have been resolved at least 5 days ago