How do I seek for issues where assignee starts with a certain set of characters?

[Jan-Olav Styrvold]

Have tried assignee ~ "Test*"  but this operator is not valid for assignee

[Hannes Obweger - JXL for Jira]

Hi @Jan-Olav Styrvold,

if you are open to solutions from the Atlassian Marketplace, this would now 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:

Once you've narrowed down your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Any questions just let me know,

Best,

Hannes 

[mauricio.groth]

Hi @Jan-Olav Styrvold

I’m Maurício, a support engineer at Digital Toucan and I’m here to help you.

Unfortunately, using JQL of Jira, you’ll not be able to do it.

In the app where my team works, JQL Search Extensions for Jira, we have the function fieldMatch, for example, you can run the query below to return all your issues that have the assignee starting with test.

issue in fieldMatch("project = SEARCH", "assignee", "test*")

Please contact our support if you have any other questions about this query. 

We’ll be happy to help you!
Best regards,
Maurício

[Michele Ghirxi]

This isn't possible through native JQL features, you would need to use an add-on to achieve what you are looking for. 

The answer here highlights one of the add-ons: https://community.atlassian.com/t5/Jira-questions/Search-in-assignee-field-using-substring/qaq-p/860753