JQL - distinct reporter?

[Tarun Sapra]

Hi,

If a project has over 500 issues and i need to get the names of the distinct reporters, any jql for it?

PS: permissions scheme changes overtime thus people who have reporter permissions now, might not be having it earlier and vice-versa, thus i need the unique list of people that ever created an issue for the project.

Thanks,

[EddieW · Accepted solution]

It is supported by Jamie's Script-Runner plugin's JQL aggregate functions, https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-AggregateExpressions

But he suggests using the built in pie charts based on a filter for a nicer visual appeal.

[Tarun Sapra]

Yes, I guess i would have to stick to pie charts only. thanks