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:
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
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 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:
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.