有类别专家帖的查询话题？

jordan-violet · 2025 年4 月 22 日 17:18

I haven’t been able to figure out how to do this—I feel I’ve exhausted my search ideas as well as help from SQL Helper and also feeding our db schema and discourse docs to a few other tools.

Is this possible?

markvanlan · 2025 年4 月 22 日 17:20

I believe what you’re looking for are topics with this custom field

github.com/discourse/discourse-category-experts

plugin.rb

3bcf46e5b


      
          
          module ::CategoryExperts
            PLUGIN_NAME = "discourse-category-experts".freeze
            CATEGORY_EXPERT_GROUP_IDS = "category_expert_group_ids"
            CATEGORY_EXPERT_AUTO_TAG = "category_expert_auto_tag"
            CATEGORY_ACCEPTING_ENDORSEMENTS = "category_accepting_endorsements"
            CATEGORY_ACCEPTING_QUESTIONS = "category_accepting_questions"
            CATEGORY_BADGE_ID = "category_experts_badge_id"
            POST_APPROVED_GROUP_NAME = "category_expert_post"
            POST_PENDING_EXPERT_APPROVAL = "category_expert_post_pending"
            TOPIC_EXPERT_POST_GROUP_NAMES = "category_expert_topic_approved_group_names"
            TOPIC_FIRST_EXPERT_POST_ID = "category_expert_first_expert_post_id"
            TOPIC_NEEDS_EXPERT_POST_APPROVAL = "category_expert_topic_post_needs_approval"
            TOPIC_IS_CATEGORY_EXPERT_QUESTION = "category_expert_topic_is_question"
          
            class Engine < ::Rails::Engine
              engine_name CategoryExperts::PLUGIN_NAME
              isolate_namespace CategoryExperts
            end
          end

topic_custom_fields wherename = category_expert_topic_approved_group_names

jordan-violet · 2025 年4 月 22 日 18:32

system · 2025 年5 月 22 日 18:32

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.

话题		回复	浏览量
Data Explorer: Posts by Category (Including Subcategories) Support data-explorer	2	1020	2021 年11 月 28 日
View total topics per category/sub category Support moderation	10	3009	2015 年11 月 18 日
Could we re-open the topic to share Explorer queries? Site feedback data-explorer	2	692	2023 年8 月 13 日
User-posted code blocks in a category Data & reporting sql-query	3	221	2024 年5 月 13 日
Content Audit : Report to pull Categories, Topics and Replies Data & reporting sql-query	3	111	2025 年3 月 2 日

有类别专家帖的查询话题？

相关话题