When in a category, default to "none" rather than "all" subcategories

artur-shaik · February 24, 2019, 3:10pm

I just had to modify some code.

lib/topic_query.rb

2d031a1be


      
          
          if @user
            result = result.joins("LEFT OUTER JOIN topic_users AS tu ON (topics.id = tu.topic_id AND tu.user_id = #{@user.id.to_i})")
              .references('tu')
          end
          
          category_id = get_category_id(options[:category])
          @options[:category_id] = category_id
          if category_id
            if options[:no_subcategories]
              result = result.where('categories.id = ?', category_id)
            else
              sql = <<~SQL
                  categories.id IN (
                    SELECT c2.id FROM categories c2 WHERE c2.parent_category_id = :category_id
                    UNION ALL
                    SELECT :category_id
                  ) AND
                  topics.id NOT IN (
                    SELECT c3.topic_id FROM categories c3 WHERE c3.parent_category_id = :category_id
                  )

Just make this line execute uncoditionally.

Topic		Replies	Views
Don't show topics from subcategories Feature	1	1838	March 13, 2015
Category filter "none" does not appear to function in some circumstances Bug	3	823	June 9, 2020
Hiding Topics From Sub-Category Support	7	1169	October 7, 2021
Is it possible to make the default category view 'none' for subcategories? Support	5	1017	June 23, 2020
Subcategory filter disappears on /none Bug fixed , categories	2	204	November 17, 2025

When in a category, default to "none" rather than "all" subcategories

Related topics