カテゴリーエキスパート投稿のクエリトピック？

jordan-violet · 2025 年 4 月 22 日午後 5: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 日午後 5: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 日午後 6:32

system · 2025 年 5 月 22 日午後 6: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	1021	2021 年 11 月 28 日
View total topics per category/sub category Support moderation	10	3013	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	112	2025 年 3 月 2 日

カテゴリーエキスパート投稿のクエリトピック？

関連トピック