How to filter tasks with same name

Question

I want to filter all the tasks in my ongoing sprint that contains the name TASKS101-XXXX, being XXXX a random number assigned to each task. Also, I want all the tasks that are related to an epic who's name is also TASKS101-XXXX.

The issue is that the name TASKS101-XXXX can be spelled in 2 different ways:

1- TASKS101-XXXX

2- [TASKS101-XXXX]

Jira is issuing the following:

"The text query '[TASKS101-*]' for the 'text' field is not valid: it is likely that your range query is incorrect."

I've tried with summary, text, and description, but the problem seems to be that Jira takes [] as a range value. How can I do it?

Vishal Biyani_2pr07j · Answer

@Hannes Obweger - JXL for Jira

You are right. JQL does not support regex like this. I should have tried it. But got mislead by the article that I have added as a reference in my reply.

Thanks for highlighting this.

Hannes Obweger - JXL for Jira · Answer

Hi @tomas serra,

welcome to the community!

I assume that this is related to how Jira does its internal indexing for full text JQL searches; unfortunately, this sometimes leads to unexpected results when searching for terms within longer sequences of characters.

This being said, if you're open to solutions from the Atlassian Marketplace, you'll find several apps that either extend JQL by additional functions, or provide their own, more powerful search mechanisms.

E.g., your use case would be trivial to solve using 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 performs a partial match by default.

This is how it looks in action:

For more advanced use cases, you can also use logical operators (AND, OR, NOT) as well as 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

Hannes Obweger - JXL for Jira · Answer

Hi @Vishal Biyani

have you verified this? I'm personally not aware that JQL would support regular expressions, and if I enter the query that you suggested, I'm getting

'\d' is an illegal JQL escape sequence. The valid escape sequences are \', ", 	, 
, , \, '\ ' and \uXXXX. (line 1, character 11)

Just trying to understand if I'm missing something here.