How do I use ~ (CONTAIN) JQL operator with Label field

[AGnieszka GRodzka]

Hi,

I want to use ~ (CONTAIN) JQL operator in my JIRA query on Label field to search for any label, that contains specific phrase.

AND labels ~ 'ServiceNow'

Is it possible ? Thanks

[Nic Brough _Adaptavist_ · Accepted solution]

I think "contains" is misleading in the name of the function, it's more "like" than "contains".  The English version of your query is closer to "and there is a label like 'ServiceNow'"

But the answer is a simple "no".  ~ searches for text in text fields.  Labels are a set of fixed terms, a select list rather than text.

[AGnieszka GRodzka]

Thanks. It explained why I cannot use it.

[John M Funk · Accepted solution]

Hi @AGnieszka GRodzka 

Did you try what you have in your question? Did it work? If not, what was wrong? 

[AGnieszka GRodzka]

@Nic Brough _Adaptavist_  replied to me and it explained the issue I have. Yes I tried, and syntax did not work.

[Mauricio Groth - __JQL Search Extensions]

Hi @AGnieszka GRodzka

As you're on Jira Cloud, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

Using this query will show any issue that contains a specific phrase in the label field:

issue in wildcardMatch("labels", “*ServiceNow*”)

Check out the documentation for more examples.
I hope this helps!
Maurício