Issue with advanced search when scoping to messages I posted

zogstrip · December 14, 2018, 9:45pm

That filter is used to search in your posts

discourse/discourse/blob/430083019dcdca0c1c04de4b2f797e71a52b77f0/lib/search.rb#L326


      
          
              posts.where("posts.id IN (
                                    SELECT pa.post_id FROM post_actions pa
                                    WHERE pa.user_id = #{@guardian.user.id} AND
                                          pa.post_action_type_id = #{post_action_type} AND
                                          deleted_at IS NULL
                                 )")
            end
          end
          
          advanced_filter(/in:posted/) do |posts|
            posts.where("posts.user_id = #{@guardian.user.id}") if @guardian.user
          end
          
          advanced_filter(/in:(watching|tracking)/) do |posts, match|
            if @guardian.user
              level = TopicUser.notification_levels[match.to_sym]
              posts.where("posts.topic_id IN (
                            SELECT tu.topic_id FROM topic_users tu
                            WHERE tu.user_id = :user_id AND
                                  tu.notification_level >= :level

Topic		Replies	Views
Advanced search: posts that I have seen Feature	12	2031	March 12, 2017
Advanced Search UI Feature	8	5337	August 30, 2018
Advanced search by post count is missing results Bug	4	1209	November 28, 2016
Seeing assigned topics in advanced search Support	8	728	October 29, 2020
How to search/filter untagged topics Support	5	1529	June 28, 2019

Issue with advanced search when scoping to messages I posted

Related Topics