Unable to perform partial search on Sprint attribute

Dilip
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 22, 2024

Hello,

Looking for help on performing partial search on Sprint field. I am trying to consolidate all stories under a specific project which has multiple scrum/agile teams. Sprint name is unique for each scrum team but has specific pattern. please refer below table.

Current Structure:

Screenshot 2024-11-23 at 9.55.50 AM.png

Ask: get the list of issues for a specific project (or multiple) grouped by Sprint.

JQL: 

project = "ABC" and sprint = S1 and sprint=FY25Q1 and "Agile Team[Dropdown]" = "Team 1"

 

Output: An unknown error occurred while trying to perform a search.

Reason for including Sprint twice is bcos am not sure how a partial string search can be done on this column. for e.g. Sprint="FY25Q1*S1". Very rarely the above query works but most often it fails with the above message. Is it an environment issue or specifying sprint twice in the query is the issue?

Appreciate if I can be guided on this.

Thanks

Dilip

2 answers

1 vote
Marc - Devoteam
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 22, 2024

Hi @Dilip 

Welcome to the community.

The sprint field is an ID field not a text field, so no partial searches are possible.

Wildcard searching can only be done on text related fields.

You could look at the marketplace app JQL Search Extensions, this offers a  wildcard search option.

Dilip
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
November 23, 2024

Thanks Marc for your response. Currently it does allow me to do partial search. For e.g. If Sprint has the value 'FY25Q1-T1-S1' and am able to search 'project=ABC and Sprint=S1' to get the results. But the concern is when there are tickets with FY24Q1-T1-S1 and FY25Q1-T1-S1, the above query results in 2 records whereas expecting to get S1 of FY25 only.

So basically my ask is to search matching the pattern 'FY25*S1'. Thats why tried the query with condition Sprint=FY25 and Sprint=S1 but results in error. 

0 votes
Hannes Obweger - JXL for Jira
Atlassian Partner
November 24, 2024

Hi @Dilip

welcome to the community!

If you're open to solutions from the Atlassian Marketplace, this would be easy to do 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 hierarchiesissue 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:

sprint-name-regex.gif

The regex that I'm using is above is

FY25Q1-..-S1

where "." is a regular expression's wildcard character  - but you really have full control here.

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events