# Advanced Search: Find posts having staff color
**URL:** https://meta.discourse.org/t/advanced-search-find-posts-having-staff-color/206325
**Category:** Feature
**Created:** [October 18, 2021, 10:25am UTC](https://meta.discourse.org/t/advanced-search-find-posts-having-staff-color/206325 "2021-10-18T10:25:53Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@aschrijver](https://meta.discourse.org/u/aschrijver)
#### Post date: [October 18, 2021, 10:25am UTC](https://meta.discourse.org/t/advanced-search-find-posts-having-staff-color/206325/1 "2021-10-18T10:25:53Z")
I have a forum where staff have marked many particularly explanatory topics/posts with staff color over time. Initially just to highlight them a bit more in the thread. But now we have the need to gradually parse all these topics/posts thus marked, and compile documentation from them.
AFAICS the Advanced Search function does not support a filter to retrieve them.
> **Feature** : This might be added as an entry in the **Only return topics/posts..** dialog with a value of **[having staff color]**
Or is there another way we could get at them with relative ease?
---
### Author:  [@JonathanShaw](https://meta.discourse.org/u/JonathanShaw)
#### Post date: [October 19, 2021, 6:42am UTC](https://meta.discourse.org/t/advanced-search-find-posts-having-staff-color/206325/2 "2021-10-19T06:42:53Z")
> [@aschrijver](#):
>
> is there another way we could get at them with relative ease?
A [data explorer](https://meta.discourse.org/t/32566?silent=true) query?
---
### Author:  [@aschrijver](https://meta.discourse.org/u/aschrijver)
#### Post date: [October 20, 2021, 9:39am UTC](https://meta.discourse.org/t/advanced-search-find-posts-having-staff-color/206325/3 "2021-10-20T09:39:08Z")
Ah, thank you @JonathanShaw! It looks like this could offer a well-enough solution for my use case. For those, like me, that were unaware of [Data Explorer](https://meta.discourse.org/t/32566?silent=true):
> [@Discourse Data Explorer](https://meta.discourse.org/t/data-explorer-plugin/32566):
>
> discourse2Summary Discourse [Data Explorer](https://meta.discourse.org/t/32566?silent=true) allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting.open_bookInstall Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately.information_source If you’re looking for examples or support for any custom queries, you can find lots of topics in our #Data & reporting category under the #sql-query tag. If there’s not one to suit your pa…
I’ll check it out and see if I can come up with the proper SQL Query (maybe it is even already listed somewhere).