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

[isdemo]

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

• yes
• no
• I dont know
• other

If the votes history is kept somewhere, can you show it somehow?
Do I need a plugin for that?

[tobiaseigen]

Take a look at this post:

Is it possible to see who voted in polls?

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…

[isdemo]

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.

[pfaffman (Jay 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 Plugin installed. Then you paste that query into Data Explorer.

Does that help?

[isdemo]

@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 Plugin 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?

[dax (Daniela)]

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

[isdemo]

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?

[dax (Daniela)]

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.