Is it possible to keep the votes history of a 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: [图片] 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.

[图片] 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?

[图片] pfaffman: [图片] 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) 2017 年9 月 1 日 19:27 2

Take a look at this post:

话题		回复	浏览量
How could I get voters from a poll? Product Support polls	7	1314	2025 年2 月 26 日
Extracting user lists from polls Feature	3	1173	2020 年8 月 15 日
Is it possible to see who voted in polls? Product Support	14	27029	2020 年4 月 9 日
Poll: Export poll results in CSV for quiz creator? Feature	10	3779	2022 年5 月 12 日
Creating and managing polls Using Discourse polls , how-to	26	44128	2026 年9 月 22 日

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

相关话题