How to Filter for Comments with Word in and not in

[Steffen Jantke]

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]

try this....

comment ~"2019 -2020"

not sure if that will get you there but lets start there

[Steffen Jantke]

Hi Jack,

Sounded like a good approach, but unfortunately it does not work.
I still see entries with values "2019" AND "2020" in comments.

Another idea?

Kind regards,
Steffen

[Steffen Jantke]

Hi @Jack Brickey, do you have another idea?

[Jack Brickey]

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

[Steffen Jantke]

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]

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

comment ~"A31122019 -B31122020"