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

system · May 22, 2025, 6:32pm

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

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

Query Topics with Category Expert posts?

Related topics