Command to obtain a report with issues without the word "DUPLICATE" in summary field/comment box?

[Luciana Apostol]

Good morning, all!

I’m trying to figure out the command to obtain all the issues created in a week, but the results should not have the word “DUPLICATE” in the summary field or in the comment box. I know the command to obtain the duplicates:

component = "A" AND created >= "2019/01/01" AND created <= "2019/01/07" AND project = "B" AND text ~ "DUPLICATE"

but I can’t modify the command to see the results without the duplicates. I have tried

component = "A" AND created >= "2019/01/01" AND created <= "2019/01/07" AND project = "B" AND text !~ "DUPLICATE"  

component = "A" AND created >= "2019/01/01" AND created <= "2019/01/07" AND project = "B" AND text != "DUPLICATE"

component = "A" AND created >= "2019/01/01" AND created <= "2019/01/07" AND project = "B" AND text IS NOT "DUPLICATE"

component = "A" AND created >= "2019/01/01" AND created <= "2019/01/07" AND project = "B" AND text NOT IN "DUPLICATE"

but no success. Can you help me out, please?

Thank you!

[Payne · Accepted solution]

!~ works, but not with the "text" field. You can use it on specific fields, such as summary, e.g.

summary !~ duplicate

Comments are a little trickier, in that you can use ~ and !~ on them, but !~ will return only issues with at least one comment in which your term doesn't appear. So, if you tried

summary !~ duplicate and comment !~ duplicate

issues that don't have any comments will not be returned. If you happen to have ScriptRunner installed, there is a hasComments() JQL function that you could use, something like

summary !~ duplicate and (comment !~ duplicate or issueFunction not in hasComments() )

[Luciana Apostol]

Thank you, your answer has been very helpful!