# מי סימן פתרון לנושא

**URL:** <https://meta.discourse.org/t/who-marked-solution-for-topic/195179>\
**Category:** Product Support\
**Created:** [27 ביוני,‏ 2021,‏ 11:00pm UTC](https://meta.discourse.org/t/who-marked-solution-for-topic/195179 "2021-06-27T23:00:32Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![simon](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simon/32/339122_2.png) [@simon](https://meta.discourse.org/u/simon)\
**Post date:** [28 ביוני,‏ 2021,‏ 5:03pm UTC](https://meta.discourse.org/t/who-marked-solution-for-topic/195179/2 "2021-06-28T17:03:55Z")

</div>

There isn’t a simple way for an admin to see who has marked a post as the solution, but the information is available in the database. It can be retrieved with a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query. Here is a basic query that does that:

```sql
--[params]
-- int :topic_id

SELECT acting_user_id FROM user_actions WHERE action_type = 15 AND target_topic_id = :topic_id

```

---

_[View the full topic](https://meta.discourse.org/t/who-marked-solution-for-topic/195179)._