How do I query the status field for items that do not include the string "imp"?

[Dave Wiggins]

I need to filter out items with a status contains the string "Imp".

[John Funk]

Hi Dave - Welcome to the Atlassian Community!

First question is how many statuses do you have total that would have that string? And can you not just list them with AND Status not in (IMP1, IMP2, IMP3)

[Suraj Aderogba]

Hi @Dave Wiggins ,

Welcome to Atlassian community.

Good question, this is a common use case when you want to exclude specific words or partial matches in Jira JQL searches.

If you’re trying to filter out any issues whose Status contains the word “Imp” (for example: Implemented, In Progress (IMP), Improvement, etc.), you can use the !~ operator in your JQL.

JQL Query:    status !~ "Imp"

This means: Return all issues where the Status field does not contain the text ‘Imp’ (case-insensitive).

Hope that helps you clean up your results list!

Suraj

[Bill Sheboy]

Hi @Suraj Aderogba - Ignite 

The CONTAINS ~ operator for JQL is not supported with the Status field.  Where were you able to make the query you suggested work in Jira?

Kind regards,
Bill

[Suraj Aderogba]

@Bill Sheboy you’re right JQL doesn’t support partial-match (~) on status field. Its a workarounds by copying the status name to a custom text field. That way, I can then run JQL with the ~ operator.

[Matteo Vecchiato]

Hi @Dave Wiggins ,

Welcome to Atlassian community.

It isn't possible to query the status containing a string, instead you can indicate the list of status.

The only workaround is to copy the status name to a custom text field and maintain it synched continously. This could be done with automation.

Having a custom text field, you can create a jql that search for a partial string.

I hope it helps.

Regards

[Gor Greyan]

Hi @Dave Wiggins

As @Matteo Vecchiatomentioned, there is no query for containgin string, when searching the statuses.

You can do it via API Call, Bulk getting all statuses, then searching among them your needed string.
/rest/api/3/statuses

You can check API's via the following link.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-status/#api-rest-api-3-statuses-get