How to filter out that someone has left comment under one ticket

[Juan Liu]

Hi

I want to create a filter like this:

(assignee is 'aa' or 'bb' or 'cc') OR (reporter is 'aa' or 'bb' or 'cc') OR (analyzed by 'aa' or 'bb' or 'cc')

For assignee is 'aa' or 'bb' or 'cc', we can use assignee in (aa,bb,cc)

For reporter is 'aa' or 'bb' or 'cc', we can use reporter in (aa,bb,cc)

For analyzed by 'aa' or 'bb' or 'cc', that means, 'aa' or 'bb' or 'cc' has analyzed and left comment for that ticket, does anyone know which field should to use or how to express?

Thanks.

[Jack Brickey]

Hi @Juan Liu , you can use commentedby in (a, b, c). However, that simply would find any issue where A, B or C commented. I'm not sure if that really translates Analyzed by. If you have a specifically defined event where users analyze an issue, then I would go with a custom field.

[Juan Liu]

Hi @Jack Brickey , thanks for your suggestion.

At start, I want to filter out the tickets that have been handled by someone, I think below sql is enough.

assignee in (aa,bb,cc) or reporter in (aa,bb,cc) or commentedby in (aa,bb,cc)

Thanks again, have a nice day~

[Jack Brickey]

Ok. if it works for you, please consider excepting the answer