Search by ticket Summary

[Roberta Day]

I have a list of over 100 tickets, the majority of them Zerto related. How can I eliminate those specific tickets so I can search for ones more important.

With my old ticketing system, all we had to do was add the "!" sign followed by Zerto in the ticket description field, and the search would refresh and not show any tickets with the word Zerto in the ticket description.

Doesn't Jira have anything like this? No use going through the hassle creating a JQL query, because it could change often depending on what we need to filter out. It's basically this:

! (exclamation point). Specifies a "not" operation. Works for string and numeric values.

Doesn't Jira utilize special characters like this to make searching easy?

Thank you,

Roberta

[Roberta Day · Accepted solution]

Thanks Walter!

Since I guess I've been spoiled with how easily this works in other systems, I was looking for a quick, one-off way to search tickets that would fluctuate day to day, or as needed. As I mentioned to Matthew, I guess I can get one of my more experienced JQL co-workers to give me a hand as needed.

Roberta

[Mathew Lederman · Accepted solution]

Roberta,

Yes, the ! function works in Jira too, but you do have to use JQL. For your example, the appropriate JQL would be:

summary !~ Zerto

 There is no way to do this within the basic search because basic search will always take what you put in the text box and try to find that exact string. 

[Roberta Day]

Thank you Matthew, appreciate your response. I can ask one of my co-workers who us good with JQL, unfortunately, I', not:)

[Walter Buggenhout · Accepted solution]

Hi @Roberta Day,

Yes it does. For text fields (like Summary), the search may not be 100% exact, though. Give the following a try:

summary !~ Zerto

(you can replace summary with other fields like Description or even text to search across multiple text fields at once)

On a side note: if categorising tickets is important, you may get better results if you put information like this in structured custom fields or labels. That will make your search (and even reporting / dashboarding capabilities) a lot easier and more reliable.

Hope this helps!

[RAHUL INGLE]

Hi All,

I am not able find # keyword in jira ticket summary section. can someone aware hot featch data.

summary ~ "#" 

[Hannes Obweger - JXL for Jira]

Hi @Roberta Day

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. One of the filtering options that is available for all fields is text filtering, which support logical operators such as NOT, AND, or OR.

This is how it looks in action:

(I'm filtering the Notes column here, but it would work the same for any other field.)

For more advanced use cases, you can also use regular expressions.

I should also add that JXL can do much more than the above: From support for configurable issue hierarchies, to issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes