how to write a JQL query to list all values starting with certain letters

Albin Pitchiah
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 16, 2024

how to write a JQL query to list all values starting with certain letters

2 answers

1 vote
Nikola Perisic
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 16, 2024

You can use the tilda ~ in your JQL. Example:

summary ~ "Example" will list out all of the issues that contain the word Example.

0 votes
Hannes Obweger - JXL for Jira
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
April 22, 2024

Hi @Albin Pitchiah

I agree that JQL's ~ and * features are probably the most obvious starting point.

If these become too cumbersome or limiting, there's a number of apps available on the Atlassian Marketplace that provide more powerful search capabilities - either by extending JQL with additional functions, or by offering their own search and filter approaches.

As an example, I believe that your use case would be easy to do using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchiesissue grouping by any issue field(s), sum-ups, or conditional formatting - as well as the ability to filter issues via regular expressions

With regular-expression-based filtering, you can apply pretty much any logic, including the one that you are after:

regex-filtering-starting-letters.gif

This would find all issues with an assigned group (that's a custom field of type single-value select) that starts with A, B, C, or D - of course, this also works for any other field and any other regular expression.

Any questions just let me know,

Best,

Hannes

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events