--------------------------------------------------------------------------------
Anton Kalinin wrote:
> It would be great to be able to set more than 3 sort columns in custom queries. Maybe, 10 might be enough?
>
> Here is a scenario to sort issues I'm going to use in my organization, it lacks the amount of sort columns:
>
> # Group issues by the priority field;
> # Sort by the Parent task field to visualize the issue hierarchy;
> # Sort by the Status field descending. The nearer an issue is to be done, the higher it should be in the list. It can help not to keep a lot of incomplete issues.
> # Sort by the % Done field descending due to the consideration above.
> # Sort by the # field ascending to order them in the creation order.

You can change it easily in your redmine copy.

In your app/models/query.rb (changed : .slice(0, 3) to .slice(0, arg.length))
<pre>
<code class="Ruby">
def sort_criteria=(arg)
c = []
if arg.is_a?(Hash)
arg = arg.keys.sort.collect { |k| arg[k] }
end
if arg
c = arg.select { |k, o| !k.to_s.blank? }.slice(0, arg.length).collect { |k, o| [k.to_s, (o == 'desc' || o == false) ? 'desc' : 'asc'] }
end
write_attribute(:sort_criteria, c)
end
</code>
</pre>

And in app/views/queries/_form.html.erb:
change 3 to any number
<pre>
<code class="erb">
<fieldset><legend><%= l(:label_sort) %></legend>
<% 3.times do |i| %>
</code>
</pre>
--------------------------------------------------------------------------------