Create a JQL filter that filters A-D items that starts with A until D, then do another filter E-H.

[Heloísa Megda]

Hello there,

I wanna do quick filters to separate alphabetical names, so for example, selecting just items that the field "Company Name" starts with A until D.

I tried to order by ASC but it doesn't split by groups.

Someone can help me?

Heloísa Megda 

[Evgenii · Accepted solution]

Hi, @Heloísa Megda 

Standard JQL doesn't support regexp search, so, it's not possible to make search. like you're trying to do.

There is a workaround, but it's not very correct, when it looks for issues. If Company Name consists from 2+ words, it will look at all words, and tries to find matching.

As you see in example, query found issues, where second word starts from A, and issues, where first word starts from T. If it's not very critical, and company names consist from one word, or are named like Company_Name, you can try to use such query:

summary ~ "A* || B* || C* || D*"

[Heloísa Megda]

Thanks! It worked

[Trudy Claspill]

Jira does not natively support a JQL function to search a text field specifically for the text that appears at the beginning of the field. The CONTAINS operator (~) will search the entire field so if you did
"Company Name" ~ "a*"

The search results would contain issues where any word within Company Name begins with an "a".

Are you willing to consider using a third party app to meet your requirement?