Query Topics with Category Expert posts?

jordan-violet · April 22, 2025, 5:18pm

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 · April 22, 2025, 5:20pm

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 · April 22, 2025, 6:32pm

Topic		Replies	Views
Discourse Category Experts Plugin official , category-experts	2	8860	March 5, 2025
Data Explorer Tutorial - Part 1 - Writing Your First Query Data & reporting data-explorer , sql-tutorial	0	1245	September 5, 2023
Discourse Data Explorer Plugin official , data-explorer	23	77334	April 16, 2025
Data Explorer Queries accessible to public Feature data-explorer	11	3764	October 9, 2020
Howto/doc on 'data explorer' Support	15	694	October 30, 2024

Query Topics with Category Expert posts?

Related topics