How do I use wild cards to find all Keys that end with -6?

Mitchell Gurnett

We use a script to create certain tasks in Jira.  So my TEST phase Jira tasks all end with -6 under an Epic (e.g. F1313-6), but have multiple other TEST phases where the key is system assigned.  I'm trying to  query based on the Key field using a wild card and it is not returning the issues (e.g. issuetype = Task AND Summary ~ "FAT" AND status != Done AND key = "F*-6")

ChristopherChilds

One can not search for a key with "Key = 6" as Key is a system field, when trying you will get the following error:

The operator '~' is not supported by the 'key' field.

What you could do is to create a Custom Field to indicate the Type of test it is. Then run a query against this?
If you have Jira Automation, you could also just add a rule to check for the value of the Key and assign a value to your custom field.
If you have Scriptrunner you can ask your Jira admins to provide a post function or a scripted field to perform the check.