filter_after_updated_by_and_last_updated_by_v3.patch - Redmine

         add_available_filter "priority_id",
           :type => :list, :values => IssuePriority.all.collect{|s| [s.name, s.id.to_s] }
         author_values = []
         author_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?
         author_values += users.collect{|s| [s.name, s.id.to_s] }
         user_values = []
         user_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?
         user_values += users.collect{|s| [s.name, s.id.to_s] }
         add_available_filter("author_id",
           :type => :list, :values => author_values
         ) unless author_values.empty?
           :type => :list, :values => user_values
         ) unless user_values.empty?
         assigned_to_values = []
         assigned_to_values << ["<< #{l(:label_me)} >>", "me"] if User.current.logged?
-...
             :values => subprojects.collect{|s| [s.name, s.id.to_s] }
         end
         unless user_values.empty?
           add_available_filter("updated_by",
             :type => :list, :values => user_values
+          )
           add_available_filter("last_updated_by",
             :type => :list, :values => user_values
+          )
         end
         add_custom_fields_filters(issue_custom_fields)
         add_associations_custom_fields_filters :project, :author, :assigned_to, :fixed_version
-...
         end
       end
       def sql_for_updated_by_field(field, operator, value)
         db_table = Journal.table_name
         "#{Issue.table_name}.id IN (SELECT #{db_table}.journalized_id FROM #{db_table} WHERE #{db_table}.journalized_type='Issue' AND #{db_table}.journalized_id = #{Issue.table_name}.id AND " +
           sql_for_field(field, operator, value, db_table, 'user_id') + ')'
       end
       def sql_for_last_updated_by_field(field, operator, value)
         db_table = Journal.table_name
         "#{Issue.table_name}.id IN (SELECT max(#{db_table}.journalized_id) FROM #{db_table} WHERE #{db_table}.journalized_type='Issue' AND #{db_table}.created_on = #{Issue.table_name}.updated_on AND #{db_table}.journalized_id = #{Issue.table_name}.id AND " +
           sql_for_field(field, operator, value, db_table, 'user_id') + ')'
       end
       def sql_for_relations(field, operator, value, options={})
         relation_options = IssueRelation::TYPES[field]
         return relation_options unless relation_options

           operator = operator_for(field)
           # "me" value substitution
           if %w(assigned_to_id author_id user_id watcher_id).include?(field)
           if %w(assigned_to_id author_id user_id watcher_id updated_by last_updated_by).include?(field)
             if v.delete("me")
               if User.current.logged?
                 v.push(User.current.id.to_s)

       field_default_version: Default version
       field_remote_ip: IP address
       field_textarea_font: Font used for text areas
       field_updated_by: Updated by
       field_last_updated_by: Last updated by
       setting_app_title: Application title
       setting_app_subtitle: Application subtitle

     issues_001:
       created_on: <%= 3.days.ago.to_s(:db) %>
       project_id: 1
       updated_on: <%= 1.day.ago.to_s(:db) %>
       updated_on: <%= 1.days.ago.to_date.to_s(:db) %>
       priority_id: 4
       subject: Cannot print recipes
       id: 1
-...
     issues_006:
       created_on: <%= 1.minute.ago.to_s(:db) %>
       project_id: 5
       updated_on: <%= 1.minute.ago.to_s(:db) %>
       updated_on: <%= 1.days.ago.to_date.to_s(:db) %>
       priority_id: 4
       subject: Issue of a private subproject
       id: 6
-...
       id: 14
       created_on: <%= 15.days.ago.to_s(:db) %>
       project_id: 3
       updated_on: <%= 15.days.ago.to_s(:db) %>
       updated_on: <%= 15.days.ago.to_date.to_s(:db) %>
       priority_id: 5
       subject: Private issue on public project
       fixed_version_id:

       user_id: 2
       journalized_id: 1
     journals_003:
       created_on: <%= 1.days.ago.to_date.to_s(:db) %>
       created_on: 2006-07-19 21:09:50 +02:00
       notes: "A comment with inline image: !picture.jpg! and a reference to #1 and r2."
       id: 3
       journalized_type: Issue
-...
       journalized_id: 6
     journals_005:
       id: 5
       created_on: <%= 1.days.ago.to_date.to_s(:db) %>
       created_on: <%= 15.days.ago.to_date.to_s(:db) %>
       notes: "A comment on a private issue."
       user_id: 2
       journalized_type: Issue
       journalized_id: 14
     journals_006:
       id: 6
       created_on: 2006-07-19 21:07:27 +02:00
       notes: "New updates"
       user_id: 3
       journalized_type: Issue
       journalized_id: 3

       end
       def test_last_journal_id_without_journals_should_return_nil
         assert_nil Issue.find(3).last_journal_id
         assert_nil Issue.find(4).last_journal_id
       end
       def test_journals_after_should_return_journals_with_greater_id

                :queries,
                :projects_trackers,
                :custom_fields_trackers,
                :workflows
                :workflows, :journals
       def setup
         User.current = nil
-...
         assert !result.include?(i3)
       end
       def test_filter_updated_by
         query = IssueQuery.new(:name => '_')
         filter_name = "updated_by"
         assert_include filter_name, query.available_filters.keys
         query.filters = {filter_name => {:operator => '=', :values => [2]}}
         assert_equal [1,2,14], find_issues_with_query(query).map(&:id).uniq.sort
         query.filters = {filter_name => {:operator => '=', :values => [4]}}
         assert_equal [], find_issues_with_query(query).map(&:id).uniq.sort
         query.filters = {filter_name => {:operator => '!', :values => [3]}, 'project_id' => {:operator => '=', :values =>[3]}}
         assert_equal [14], find_issues_with_query(query).map(&:id).uniq.sort
       end
       def test_filter_updated_by_me
         User.current = User.find(1)
         query = IssueQuery.new(:name => '_', :filters => { "updated_by" => {:operator => '=', :values => ['me']}})
         assert_equal [1,6], find_issues_with_query(query).map(&:id).uniq.sort
       end
       def test_filter_last_updated_by
         query = IssueQuery.new(:name => '_')
         filter_name = "last_updated_by"
         assert_include filter_name, query.available_filters.keys
         query.filters = {filter_name => {:operator => '=', :values => [2]}}
         assert_equal [1,2,14], find_issues_with_query(query).map(&:id).uniq.sort
         query.filters = {filter_name => {:operator => '!', :values => [1,2]}}
         assert_equal [3], find_issues_with_query(query).map(&:id).uniq.sort
       end
       def test_user_custom_field_filtered_on_me
         User.current = User.find(2)
         cf = IssueCustomField.create!(:field_format => 'user', :is_for_all => true, :is_filter => true, :name => 'User custom field', :tracker_ids => [1])

Project

General

Profile

Redmine

Feature #17720 » filter_after_updated_by_and_last_updated_by_v3.patch