How to Filter for Comments with Word in and not in

Question

Hi everyone,

I'm trying to filter for any issues, which contain the comment "A31122019", but not "B31122020". If both is in any comments, the entry should not appear in the result list. I just need those, where "A31122019" is in any comment and "B31122020" is missing.

JQL should look as something like this:

(comment ~ A31122019 AND comment !~ B31122020)

Complete query is as follows:

project = XXX AND issuetype not in (Epic, Sub-task) AND ("Epic Link" != XXX-100 OR "Epic Link" is EMPTY) AND status not in (resolved, closed) AND summary !~ Deployment AND comment ~"A31122019 -B31122020" ORDER BY issuetype ASC, "Epic Link" ASC, summary ASC

Does anyone know how to handle this?

Kind regards,
Steffen

Jack Brickey · Answer

just for grins to help w/ isolating what works and doesn't can you remove the 'noise' and just do this...

comment ~"A31122019 -B31122020"

Steffen Jantke · Answer

Sure, here you are. I'll also add the query to my post.

project = XXX AND issuetype not in (Epic, Sub-task) AND ("Epic Link" != XXX-100 OR "Epic Link" is EMPTY) AND status not in (resolved, closed) AND summary !~ Deployment AND comment ~"A31122019 -B31122020" ORDER BY issuetype ASC, "Epic Link" ASC, summary ASC

Jack Brickey · Answer

Can you share your exact JQL to see if I have any thoughts?