# Creating and managing polls

**URL:** <https://meta.discourse.org/t/creating-and-managing-polls/77548>\
**Category:** Using Discourse\
**Tags:** polls, how-to\
**Created:** [January 9, 2018, 3:49am UTC](https://meta.discourse.org/t/creating-and-managing-polls/77548 "2018-01-09T03:49:23Z")\
**Posts on this page:** 1\
**Showing post:** 120

<div class="post-metadata">

**Author:** ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)\
**Post date:** [December 20, 2024, 5:48pm UTC](https://meta.discourse.org/t/creating-and-managing-polls/77548/120 "2024-12-20T17:48:02Z")

</div>

You can do it with [data explorer](https://meta.discourse.org/t/32566?silent=true). I asked the [AI](https://ask.discourse.com/)  
“Is it possible to export the results of every single poll from different channel for reporting purposes using [data explorer](https://meta.discourse.org/t/32566?silent=true)” and it gave this query:

```plaintext
SELECT  
    p.topic_id, 
    p.name AS poll_name,
    o.id AS option_id, 
    o.html AS option_text, 
    COUNT(v.id) AS vote_count
FROM polls p
JOIN poll_options o ON p.id = o.poll_id
LEFT JOIN poll_votes v ON o.id = v.poll_option_id
GROUP BY p.topic_id, p.name, o.id, o.html
ORDER BY p.topic_id, p.name, o.id;

```

it looks like it might work?

---

_[View the full topic](https://meta.discourse.org/t/creating-and-managing-polls/77548)._