Sujets de requête avec des posts d'experts en catégories

jordan-violet · Avril 22, 2025, 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 · Avril 22, 2025, 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 · Avril 22, 2025, 6:32

system · Mai 22, 2025, 6:32

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

Sujet		Réponses	Vues
Data Explorer: Posts by Category (Including Subcategories) Support data-explorer	2	1018	Novembre 28, 2021
View total topics per category/sub category Support moderation	10	3007	Novembre 18, 2015
Could we re-open the topic to share Explorer queries? Site feedback data-explorer	2	692	Août 13, 2023
User-posted code blocks in a category Data & reporting sql-query	3	221	Mai 13, 2024
Content Audit : Report to pull Categories, Topics and Replies Data & reporting sql-query	3	109	Mars 2, 2025

Sujets de requête avec des posts d'experts en catégories

Sujets connexes