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

[Albin Pitchiah]

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

[Nikola Perisic]

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

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

[Hannes Obweger - JXL for Jira]

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 hierarchies, issue 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:

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