Is it possible to keep the votes history of a poll? poll If the votes history is kept somewhere, can you show it somehow? Do I need a plugin for that?

Take a look at this post: [image] Is it possible to see who voted in polls? Support 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…

So is it possible to somehow discover and present the below info from the poll I just created? 1/9/2017 12:25 Is it possible to keep the votes history of a poll? 0 “yes”, 0 “no”, 1 “I dont know”, 0 “other” 1/9/2017 12:45 Is it possible to keep the votes history of a poll? 1 “yes”, 0 “no”, 1 “I dont know”, 0 “other” e.t.c. Could you please answer to me on that, because I dont understand the code of the link you provided.

[image] isdemo: Could you please answer to me on that, because I dont understand the code of the link you provided. You need to have the Discourse Data Explorer installed. Then you paste that query into Data Explorer. Does that help?

[image] pfaffman: [image] isdemo: Could you please answer to me on that, because I dont understand the code of the link you provided. You need to have the Discourse Data Explorer installed. Then you paste that query into Data Explorer. Does that help? It helps a lot. But there isnt a plugin which can do that. Correct? Everytime I have to execute the sql query, then cut and paste the result somewhere. This is the only way to do that, right?

You don’t need to cut and paste. You can download the results as a csv file

Thats great. But in case I want to present this information online in my site, and for every possible poll posted in the discussion, there isnt something ready , is it? Is there a way to expose the query results to regular users? I have to write the plugin for it, right?

Discourse now support markdown tables,so the simplest thing I would do at your place is to copy the results from your csv file here Markdown Tables generator - TablesGenerator.com , generate a markdown table (no need to copy and paste single cells you can paste whole rows or columns), and then post it to a topic.

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

Product Support

tobiaseigen (Tobias Eigen) September 1, 2017, 7:27pm 2

Take a look at this post:

Topic		Replies	Views
How could I get voters from a poll? Product Support polls	7	1315	February 26, 2025
Extracting user lists from polls Feature	3	1178	August 15, 2020
Is it possible to see who voted in polls? Product Support	14	27032	April 9, 2020
Poll: Export poll results in CSV for quiz creator? Feature	10	3783	May 12, 2022
Creating and managing polls Using Discourse polls , how-to	26	44143	September 22, 2026

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

Related topics