# Query Topics with Category Expert posts?

**URL:** https://meta.discourse.org/t/query-topics-with-category-expert-posts/363020
**Category:** Data & reporting
**Tags:** data-explorer, category-experts
**Created:** [April 22, 2025, 5:18pm UTC](https://meta.discourse.org/t/query-topics-with-category-expert-posts/363020 "2025-04-22T17:18:12Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![jordan-violet](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jordan-violet/32/281428_2.png) [@jordan-violet](https://meta.discourse.org/u/jordan-violet)
#### Post date: [April 22, 2025, 5:18pm UTC](https://meta.discourse.org/t/query-topics-with-category-expert-posts/363020/1 "2025-04-22T17:18:12Z")

</div>

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?

---

<div class="post-metadata">

### Author: ![markvanlan](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/markvanlan/32/160087_2.png) [@markvanlan](https://meta.discourse.org/u/markvanlan)
#### Post date: [April 22, 2025, 5:20pm UTC](https://meta.discourse.org/t/query-topics-with-category-expert-posts/363020/3 "2025-04-22T17:20:47Z")

</div>

I believe what you’re looking for are topics with this custom field

> <https://github.com/discourse/discourse-category-experts/blob/3bcf46e5b56c15004f4191939ddbed00ce4f2b11/plugin.rb#L32>

`topic_custom_fields` where`name = category_expert_topic_approved_group_names`

---

<div class="post-metadata">

### Author: ![jordan-violet](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jordan-violet/32/281428_2.png) [@jordan-violet](https://meta.discourse.org/u/jordan-violet)
#### Post date: [April 22, 2025, 6:32pm UTC](https://meta.discourse.org/t/query-topics-with-category-expert-posts/363020/4 "2025-04-22T18:32:25Z")

</div>

![](https://media.tenor.com/_j8Z364O408AAAAC/i-would-pay-back-with-my-life-if-i-had-to-snake-eyes.gif)

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [May 22, 2025, 6:32pm UTC](https://meta.discourse.org/t/query-topics-with-category-expert-posts/363020/5 "2025-05-22T18:32:45Z")

</div>

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