Wildcard searches on sprint name

[UserXYZ]

We have about 20 pods -each with their own sprints.  Their sprint names will contain similar prefixes but they will have the option to add text freeform following a set prefix  (S20181008_xxx, S20181008_yyy, S20181008_zzz ,S20181022_xxx, S20181022_yyy, S20181022_zzz .  Need to be able to query and pull data for various sprints across all teams based on substrings of the prefix - i.e. October, or for Nov.  . 

Given the number of sprints and teams it is not efficient to have to select them individually - Having the sprint name turned into a number further complicates the issue given that never know which ones have already been selected.   

Is there a way to do wildcard searches some way on sprint name ?  Or is the only option to export all data and do reporting externally ? 

[Robert Jahrling]

Use 

sprint = "S201810"

Partial text in that search is treated as a wildcard.

[Jesus Cortes]

No, this option does not work since sprint is a numeric field... I don't have an alternate answer tho, I am looking one myself

[Jesus Cortes]

Sorry, forgot to clarify... I am talking about JQL, if you enter a partial sprint name while in the UI, then Jira can recognize the sprint and ultimately retrieves the sprint number, however you cannot use that expression as part of a JQL sentence.

[Fazila Ashraf]

Hi @UserXYZ

As far as i know, wild card searches are possible only for text field types.

If you have the sprint name mentioned in comments of the ticket, you could run something like 

comment ~ "S20181008_*"

But, no... that wont work as anyone can comment such a text... :(

Then i would say export and processing it outside jira might be the way..