Issue with advanced search when scoping to messages I posted

AndreaPi · 12 ديسمبر 2018، 5:09م

Hi,

when searching for posts by a certain user, in topics to which I have posted, the advanced search returns 0 hits, even though this user has posted answers in many of my topics. This is happening on the RStudio community, which uses Discourse:

This advanced search feature was introduced last year:

I would have posted in that topic, but I can’t because it’s now closed, so I’m opening a new one. Thanks for your attention and for this wonderful platform,

Andrea

codinghorror · 13 ديسمبر 2018، 12:13ص

Can you repro this @jomaxro?

jomaxro · 13 ديسمبر 2018، 3:29ص

Yep, this isn’t working (or the in:posted filter doesn’t do what we think it does). @codinghorror and I have posted in many of the same topics, yet https://meta.discourse.org/search?expanded=true&q=%40codinghorror%20in%3Aposted returns 0 results.

zogstrip · 14 ديسمبر 2018، 9:45م

That filter is used to search in your posts

github.com

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

codinghorror · 14 ديسمبر 2018، 10:51م

So that is the confusion. This is being interpreted as “search all topics I posted in” when in reality it means “search all my posts”.

AndreaPi · 15 ديسمبر 2018، 9:17ص

Ok. So which advanced search would allow me to all posts by User X, in topics in which I posted? Or, if this isn’t possible, all my posts, in topics opened by User X? Thanks

codinghorror · 15 ديسمبر 2018، 10:44ص

You might need to use the Data Explorer plugin for that. It’s kind of an unusual query.

الموضوع		الردود	مرات العرض
Searching for content effectively Using Discourse search	9	3083	26 يونيو 2025
Search filter - only topics / only posts Feature search	7	964	14 مارس 2023
Search just the initial topic post, excluding replies? Support	3	1189	23 يونيو 2015
Advanced search: posts that I have seen Feature	12	2048	12 مارس 2017
Advanced search by post count is missing results Bug	4	1219	28 نوفمبر 2016

Issue with advanced search when scoping to messages I posted

الموضوعات ذات الصلة