How can I exclude tickets based on a unique comment?

[Mark Gillespie]

Hi all,

I currently have a dashboard setup that runs a rich text filter based on labels.

I want to 'review' these tickets, and then have a way to separate them out into another rich text filter.

I have built one to drop in any that have a unique text in the comment field, but they still show in the original filter.  

Can I exclude tickets from the original filter once reviewed by adding that same comment.  I've tried to run a few tests, but all I can do is exclude everything without any comments, i only want to exclude the unique comment I would place, so any others - with comments and without I'd still want to see.

[Ben Finn · Accepted solution]

Hi @Mark Gillespie

I think I understand what you are trying to do. Whenever I need to control or organize tickets around automation or JQL, Ill use a label. You can add a label as part of the automation to show that its been processed or you will have to do it manually.

Hopefully this helps a bit.

Good luck!

[Mark Gillespie]

Hi, yeah so we have a label already from another team, that brings it into th rich text filter.  But what i want to do is have them moved from this filter into another 'assessed' filter based on us reviewing it.  I don't want to remove the label, as i still need it in the dashboard but in another filter, which i've done using a comment and unique reference to that comment.  But i want to remove it from the original filter by excluding any that have just that comment in the comment field

[Ben Finn]

A ticket can have as many labels as you want it to. You could ask it to show in the filter based on label A and not show if it also has label B.

[Ben Finn]

I have a process somewhat similar for sending emails in an automation. It goes in stages. If it matches criteria then it sends an email and adds label A, then when it matches the second criteria it sends another email and adds another label, never removing the old label.

[Mark Gillespie]

Hi Ben, yeah makes sense - i think there are access related questions around updating tickets because we are somewhat 'jumping on' another process, but it appears to be the best solution to this

Thanks for your help!

[Ben Finn]

@Mark Gillespie

Glad to hear it! If you feel that way can I please ask you to Accept this solution? Thanks!

[Ekaterina Smykova]

Hi @Mark Gillespie ,

Atlassian has provided with workaround which you can find here: https://confluence.atlassian.com/jirakb/jql-queries-search-for-issues-that-do-not-contain-text-1018761257.html

Does it help? 

Regards,

Katja

[Mark Gillespie]

Hi, thanks for this.  I'm not sure if it does, i want to exclude any tickets that have **Reviewed** in the comment section. but when i try to exclude that, it also excludes any tickets where no comments have been placed in.  which isn't what i wanted.