How to filter assignee using a substring?

[johnnav]

I have a need to get list of issues assigned to folks with a particular string in their name. ex: if the assignee name has an "X" at the end of the name, how do I query such issues?

i need to do something like " assignee contains ("X")" but dont think JIRA filter has that option.

Any help is appreciated.

[Mohamed Benziane]

Hi @johnnav

It is not a JQL function in jira you will need to do your search with an addon if it can.

Regards.

[johnnav]

Thanks for the prompt response. Is there an addon you would suggest?

[Mohamed Benziane]

hi,

I don't use it but you can take a look at this addon

https://marketplace.atlassian.com/apps/1218767/smart-ql-sql-jql-easy-reporting?hosting=server&tab=pricing

regards