how can part of label be used for filtering?

[frans vervuurt]

I use labels to relate epics/issues related to a project. Therefore, I label them "project_XXX" or "project_YYY" or "project_ZZZ". (Epics/issues can also have additional labels.)

I want to get an overview of all epics/issues related to a project, so filtering something like: label contains "project_". Can this be done?

Alternatively, can labels be included in an excel export, so I can filter in excel??

Thanks!

[Mohamed Benziane · Accepted solution]

Hi,

In Jira you can use label in JQL like that :

labels in("test", "test2")

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-fields-reference-939938743.html#Advancedsearchingfieldsreference-labelsLabels 

[frans vervuurt]

Hi Mohamed,

Thanks a lot for your response.

This does not cover what I look for.

I need to filter on labels containing specific text, like "project_" in the example above.

In your example, filter on labels containing "test".

Or: can I export all information including labels to an excel and do the filtering there?

Thanks,

Frans

[Mohamed Benziane]

Hi,

This functionnality is not supported for this field. So you will need to export them and make some formula in excel. Look at Jack's response in the thread below :

https://community.atlassian.com/t5/Jira-questions/How-do-I-find-all-labels-in-Jira/qaq-p/1784796

[frans vervuurt]

Hi Mohamed,

Thanks again for your answer.

I checked the export with Jack's response, and I think I will manage.

So, solved :-)