how to filter a customized field contain "AKS"

[Cheng Zhi Jie]

hello,

I am wondering if there is a JQL can filter a customized field like “Software Component” which contain "AKS" value? Thanks in advance. 

[John Funk · Accepted solution]

Hi Cheng,

Is the custom field a text field? If so, then yes you can can use the ~ (tilde) to query it. 

For example: "Software Component" ~ AKS

[Cheng Zhi Jie]

Thanks @John Funk for your idea. I have checked unfortunately it is label type field hence it does not support ~. :(

[John Funk]

Ah, it's a labels type field. The answer would be to use wildcards, but that's not available either! You can vote for and follow that request here:  https://jira.atlassian.com/browse/JRACLOUD-23038

Here's a solution using ScriptRunner if you have that. Or desperate enough for the need to add the app. 

https://community.atlassian.com/t5/Jira-questions/How-to-search-for-labels-with-a-wildcard/qaq-p/142696

[Cheng Zhi Jie]

Thank you for the advice. I think ScripRunner issueFunction in issueFieldMatch solve my problem. Really appreciate! @John Funk 

[John Funk]

Great! Happy to help.

[YY Brother]

Hi @Cheng Zhi Jie 

你可以直接在事务搜索里，选择那个自定义字段名称，然后在下拉列表里选择 AKS。切换到高级查询后，就能看到你所需的 JQL 了。

YY哥

[Cheng Zhi Jie]

谢谢，不行，不是=AKS，是包含AKS字符的

[YY Brother]

那就很麻烦了，标签类型自定义字段的值可以随意自定义，且区分大小写，aKs, Aks, akS 都不一样。我一般会慎用这个字段类型。

[Aisha M]

You can try.

"Software Component" ~ "AKS"

[Cheng Zhi Jie]

thank you @Aisha M

It is not supported since the field is not text type.

[Aisha M]

Oh, thats a bummer.

Could you try,

"Software Component" = "AKS"

If "AKS" is part of multiple labels,

"Software Component: in ("AKS")