How to filter tasks with same name

[tomas serra]

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?

[Hannes Obweger - JXL for Jira]

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

[Vishal Biyani]

have you tried ~ operator in jql?

summary ~ 'TASKS101\d{4}'

For issues under an epic, can you try

parent = <epic number> and summary ~ 'TASKS101\d{4}'

This will return all standard Issues that are linked to an epic and contains summary TASKS101XXXX

You can refer to this article 

https://community.atlassian.com/t5/Jira-questions/JQL/qaq-p/2542345

[Hannes Obweger - JXL for Jira]

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 \', \", \t, \n, \r, \\, '\ ' and \uXXXX. (line 1, character 11)

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

[Vishal Biyani]

@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.