Error when searching for a literal value in the fixVersion field

[Andre de Castro]

Hi.

 In Jira, when I run a JQL with the search examples below, I get a successful result:

fixVersion ~ “*STG*” AND statusCategory != Done

fixVersion ~ “*TRUNK*” AND statusCategory != Done

 
But when I do the search below:

fixVersion ~ “*PROD*” AND statusCategory != Done

an error occurs and I get the following message:

JQL error The terminal clause [*PROD*] resolves too many literals

When I accept the AI's suggestion, the error message no longer appears, but the query returns no results, even though there are records to be displayed.

 I only use native Jira.

I couldn't find a solution in my searches. Does anyone have any advice on how to solve this?

[Marc - Devoteam · Accepted solution]

Hi @Andre de Castro 

The error means the too many versions are found based on the fuzzy search clause.

Also see using-wildcards-in-jql-search-leads-to-errors 

Adjust your search to limit the results