how to write a JQL query to list all values starting with certain letters
You can use the tilda ~ in your JQL. Example:
summary ~ "Example" will list out all of the issues that contain the word Example.
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
It looks like you're new here. Sign in or register to get started.
