JQLQuery

[Eric Roetenberg]

Hello

I am looking for a JQL that does the following
Of a number of projects all issue that meet the following Resolved date is greater than xxxxxxx or resolved date is empty

If I do it like this I also get all issues from projects that are not in the JQL

project in (ISMSP, ISMT, PCMMWR, PCMRPA, SCSCPC, SCSIAM, SCSIK, SCSIP, SCSIAMBST, SCSSOC, WPLS, WPLDW, WPLITS, WPLCCT) AND resolved >= 2023-10-02 or resolved is EMPTY

Grtz.  Eric

[Craig Nodwell · Accepted solution]

Hi @Eric Roetenberg it's your OR clause.  put the last two statements into brackets.  re:
AND (resolved >= 2023-10-02 or resolved is EMPTY)

[Harald Seyr · Accepted solution]

Hi @Eric Roetenberg 

I am not sure, but maybe this is related to the "or" part of your JQL. Please check if brackets fix the issue:

project in (ISMSP, ISMT, PCMMWR, PCMRPA, SCSCPC, SCSIAM, SCSIK, SCSIP, SCSIAMBST, SCSSOC, WPLS, WPLDW, WPLITS, WPLCCT) AND (resolved >= 2023-10-02 or resolved is EMPTY)

Regards,

Harald