Search tickets by reporter and text at once

[Oscar Gagnon]

Hello,

I want to be able to find all tickets related to someone if that person is the reporter or just mentionned in a ticket.

Right now, the only way I found is to do this:

Using basic search, add the reporter field and select the person.
Using basic search, search for the name of the person in the text field.
Switch to JQL.
Change the "AND" to an "OR".

This gives me the results I want but it's not very practical to have to do that for each search.

Ideally, the text field would also search the reporter directly. Is that something that can be done?

Thank you.

[Dan Breyen · Accepted solution]

If you use the text only search, I would NOT expect the JQL to find them if their name is in the reporter field because the reporters are not stored as text.  You would need to 'OR' the two different queries together so it's searching multiple fields.  

You can also save that JQL query once you have it working so you don't have to save it over and over again.  You should be able to save it as a filter in Jira.

[Oscar Gagnon]

I was hoping there would be a way to enable the text field to also search the reporter field but that will do the job.

Thank you for your help.

[Joseph Chung Yin · Accepted solution]

@Oscar Gagnon -

Welcome to the community.  You can try the usage of text search combined with search for reporter in one.  I am sure you already doing so -

JQL example - project = xxxx and (reporter = <userid> or text ~ "<userid>")

You can just use text ~ criteria only and without using the reporter field, it should still give you all issues where the specific user is associated to.  NOTE - text is not an actual field, it is just a syntax for search any text value in the issues.

You can also save your JQL filter and reuse it without recreating it from scratch every time.

Hope this helps.

Best, Joseph Chung Yin

Jira/JSM Functional Lead, Global Technology Applications Team

Viasat Inc.

[Oscar Gagnon]

Hello,

If I use only the text ~ criteria it doesn't find the tickets where the reporter is equal to that criteria. I need to also add the reporter field.

It works only if their name was also mentionned somewhere in text in the ticket. If the only entry for their name is in the reporter field, using only the text ~ criteria will not find them.

Thank you for your help.

[Joseph Chung Yin]

@Oscar Gagnon 

That is why I suggested in my previous response - JQL example - project = xxxx and (reporter = <userid> or text ~ "<userid>")

If my suggestion helped you, please click on Accept answer button when you have a chance.

Best, Joseph