Redmine

I have this issue here too. I'd like to see tickets submitted by any user.
But loading thousands of users in the drop-down is not a good solution.

This would require some changes in the Query model and to replace the field with a sort of auto-complete field.

If displaying the list of all users is not a problem for you, you can use:

user_values += User.find(:all).sort.collect{|s| [s.name, s.id.to_s] }

jp jp: Where would I use that?

Understand about the size of the list. Maybe a option setting?

I think you can limit the size of the list by using just those userids that are in the issues for the project/tracker (still could be thousands for a internet wide "public" project)

FTR:
Jean-Philippe Lang wrote at #4398#note-1:

We can not list all users in this field, we need to change this filter to an auto-complete field first.

issues_query.rb

173c177,187
<     author_values += users.collect{|s| [s.name, s.id.to_s] }
---
>    if project 
>      from_user = []
>      project.issues.group(:author_id).each{|i| from_user << [i.author.name, i.author_id.to_s]}
>      from_user.uniq!
>      from_user.sort!
>      author_values += from_user
>      else
>      author_values += users.collect{|s| [s.name, s.id.to_s] }
>      end

this way works but slow when big amount of issues
(After adding group(:author_id) - works much faster)

173c174,182
<     author_values += users.collect{|s| [s.name, s.id.to_s] }
---
>    if project 
>       time_range = (Time.now - (3600*24*180))..(Time.now)
>       author_values += project.issues.where(issues: { created_on: time_range }).group(:author_id).preload(:author).collect{|s| [s.author.name, s.author_id.to_s]}
>      author_values.sort!
>      else
>      author_values += users.collect{|s| [s.name, s.id.to_s] }
>      end

+1

This is long waited and reported multiple times. Any chance to get this done?

Another try to solve this issue. for me it's work fine for about 250 active users.

in issue_query.rb after author_values=[]

if project
        from_user = []
        time_range = (Time.now - (3600*24*730))..(Time.now)
        issues_cross = Issue.cross_project_scope(project, 'descendants')
        from_user += issues_cross.where(issues: { created_on: time_range }).group(:author_id).preload(:author).collect{|i| [i.author.name, i.author_id.to_s]}
        from_user.uniq!
        from_user.sort!
        author_values += from_user

time_range not required but for me a little helpful...