How to select multiple ticket on search test by spesific test summary number

[nikko wahyudi]

i have 500 tickets on my project and i want to change status no run to pass between 100 to 150 by test summary "example_SCN2_TC100" to "example_SCN2_TC150" is that possible to filter just show that ticket?

[Hannes Obweger - JXL for Jira]

Hi @nikko wahyudi

welcome to the community!

Just to add to @Hauke Bruno Wollentin's great answer: If you're open to solutions from the Atlassian Marketplace, you'll find a number of apps that extend Jira by advanced search and filter capabilities.

E.g., your use case should be easy 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. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to filter issues via regular expressions. 

With regular-expression-based filtering, you can apply pretty much any logic, including the one that you are after:

(I'm using a column "Notes" here, but it would work the same for the summary.)

The regex that I'm using is

example_SCN2_TC(1[0-4][0-9]|150)

There's a few things going on here, but it matches every number from 100 to 149 (that's the 1[0-4][0-9] part), and also 150.

Once you've identified your issues, you can work on them directly in JXL (e.g., bulk edit them via copy/paste), or trigger various operations in Jira.

Any questions just let me know,

Best,

Hannes

[Hauke Bruno Wollentin]

Sadly JQL does not support regex by default.

Without any 3rd party plugin a possible solution would be something explicit like this 

((summary ~ "example_SCN2_TC1*" and summary !~ "example_SCN2_TC15*" and summary !~ "example_SCN2_TC16*" and summary !~ "example_SCN2_TC17*" and summary !~ "example_SCN2_TC18*" and summary !~ "example_SCN2_TC19*") or summary ~ example_SCN2_TC150)

If you need to repeat this with more ranges, my personal approach would be to script this away in bash or Python or any other language using the REST API of Jira.

Also if this is a use-case for the future, I personally would add this range number into a number custom field. This allows searching for ranges like 

myRangeField >= 100 AND myRangeField <=150

[Mohaddis Hassan]

You can use JQL,

summary ~ "\"example_SCN2_TC100\""