# Is it possible to keep the votes history of a poll?

**URL:** https://meta.discourse.org/t/is-it-possible-to-keep-the-votes-history-of-a-poll/69224
**Category:** Support
**Created:** [1 سبتمبر 2017، 7:22م UTC](https://meta.discourse.org/t/is-it-possible-to-keep-the-votes-history-of-a-poll/69224 "2017-09-01T19:22:58Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![tobiaseigen](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tobiaseigen/32/539204_2.png) [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)
#### Post date: [1 سبتمبر 2017، 7:27م UTC](https://meta.discourse.org/t/is-it-possible-to-keep-the-votes-history-of-a-poll/69224/2 "2017-09-01T19:27:24Z")

</div>

Take a look at this post:

> [@Is it possible to see who voted in polls?](https://meta.discourse.org/t/is-it-possible-to-see-who-voted-in-polls/27064/12):
>
> You can run the following query to get a list of users who voted and their selected poll options. Please choose the appropriate query for your Discourse version. Query for Discourse v2.2.0.beta5 and newer -- [params] -- post\_id :post\_id -- text :poll\_name = poll SELECT u.id AS user\_id, u.username, v.poll\_option\_id AS option\_id, o.html AS option\_html FROM polls p JOIN poll\_votes v ON (p.id = v.poll\_id) JOIN poll\_options o ON (o.id = v.poll\_option\_id) JOIN users u ON (v.use…

---

_[View the full topic](https://meta.discourse.org/t/is-it-possible-to-keep-the-votes-history-of-a-poll/69224)._