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

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

我一直无法弄清楚该怎么做——我觉得我已经用尽了搜索思路，也用尽了 SQL Helper 的帮助，还将我们的数据库架构和 discourse 文档输入给了其他几个工具。

这可能吗？

markvanlan · 2025 年4 月 22 日 17:20

我认为您要找的是具有此自定义字段的主题

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 其中 name = 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	1027	2021 年11 月 28 日
View total topics per category/sub category Support moderation	10	3025	2015 年11 月 18 日
Could we re-open the topic to share Explorer queries? Site feedback data-explorer	2	695	2023 年8 月 13 日
User-posted code blocks in a category Data & reporting sql-query	3	225	2024 年5 月 13 日
Content Audit : Report to pull Categories, Topics and Replies Data & reporting sql-query	3	131	2025 年3 月 2 日

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

相关话题