redmine_add_relation_filters.patch - Redmine

app/controllers/issues_controller.rb
	1
1	2	# Redmine - project management software
2	3	# Copyright (C) 2006-2013 Jean-Philippe Lang
3	4	#

         versions = []
         categories = []
         issue_custom_fields = []
         if project
           principals += project.principals.sort
           unless project.leaf?
-...
             op = (operator == "!p" ? 'NOT IN' : 'IN')
             comp = (operator == "=!p" ? '<>' : '=')
             "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name}, #{Issue.table_name} relissues WHERE #{IssueRelation.table_name}.relation_type = '#{connection.quote_string(relation_type)}' AND #{IssueRelation.table_name}.#{target_join_column} = relissues.id AND relissues.project_id #{comp} #{value.first.to_i})"
           when "!|c", "*&o"
             op = (operator == "!|c" ? 'NOT IN' : 'IN')
             "#{Issue.table_name}.id #{op} (SELECT DISTINCT #{IssueRelation.table_name}.#{join_column} FROM #{IssueRelation.table_name}, #{Issue.table_name} relissues WHERE #{IssueRelation.table_name}.relation_type = '#{connection.quote_string(relation_type)}' AND #{IssueRelation.table_name}.#{target_join_column} = relissues.id AND relissues.status_id IN (SELECT id FROM #{IssueStatus.table_name} WHERE is_closed=#{connection.quoted_false}))"
           end
         if relation_options[:sym] == field && !options[:reverse]

         "!~"  => :label_not_contains,
         "=p"  => :label_any_issues_in_project,
         "=!p" => :label_any_issues_not_in_project,
         "!p"  => :label_no_issues_in_project
         "!p"  => :label_no_issues_in_project,
         "*&o" => :label_any_open_issues,
         "!|c" => :label_none_or_closed_issues
+      }
       class_attribute :operators_by_filter_type
-...
         :text => [  "~", "!~", "!*", "*" ],
         :integer => [ "=", ">=", "<=", "><", "!*", "*" ],
         :float => [ "=", ">=", "<=", "><", "!*", "*" ],
         :relation => ["=", "=p", "=!p", "!p", "!*", "*"]
         :relation => ["=", "=p", "=!p", "!p", "*&o", "!|c", "!*", "*"]
+      }
       class_attribute :available_columns
-...
               # filter requires one or more values
               (values_for(field) and !values_for(field).first.blank?) or
               # filter doesn't require any value
               ["o", "c", "!*", "*", "t", "ld", "w", "lw", "l2w", "m", "lm", "y"].include? operator_for(field)
               ["o", "c", "!*", "*", "t", "ld", "w", "lw", "l2w", "m", "lm", "y", "*&o", "!|c"].include? operator_for(field)
         end if filters
       end

       permission_view_private_notes: View private notes
       permission_set_notes_private: Set notes as private
       label_no_issues_in_project: no issues in project
       label_any_open_issues: any open issues
       label_none_or_closed_issues: none or closed issues
       label_any: all
       label_last_n_weeks: last %{count} weeks
       setting_cross_project_subtasks: Allow cross-project subtasks

       label_any_issues_in_project: any issues in project
       label_any_issues_not_in_project: any issues not in project
       label_no_issues_in_project: no issues in project
       label_any_open_issues: any open issues
       label_none_or_closed_issues: none or closed issues
       label_day_plural: days
       label_repository: Repository
       label_repository_new: New repository

         case "y":
         case "o":
         case "c":
         case "!|c":
         case "*&o":
           enableValues(field, []);
           break;
         case "><":
-...
     function setupAjaxIndicator() {
       $('#ajax-indicator').bind('ajaxSend', function(event, xhr, settings) {
         if ($('.ajax-loading').length === 0 && settings.contentType != 'application/octet-stream') {
           $('#ajax-indicator').show();
+        }
       });
       $('#ajax-indicator').bind('ajaxStop', function() {
         $('#ajax-indicator').hide();
       });

Redmine