Fuzzy search assignee

[evan_lin]

In my Jira project, assignee could be internal employee or customer employee. Name of customer employee has comany name as postfix, eg. perter[IBM]. How can I filter out how many tickets are assigned to customer employees? E.g. assignee ~ IBM.

[Hannes Obweger - JXL for Jira]

Hi @evan_lin,

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 perform fuzzy text matching on all your issue fields: 

For more sophisticated use cases, you can also use regular expressions.

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 

[Florian Bonniec]

Hi @evan_lin 

You cannot has assignee is not a free text field so ~ is not available.

I think best way would be to have your customer into a group, then use assignee in membersOf("") function.

Regards