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

סיכום מבוסס בינה מלאכותית

In a Support category discussion titled “Is it possible to keep the votes history of a poll?”, isdemo asks whether poll vote history is stored and if it can be displayed. tobiaseigen directs them to a meta.discourse.org post for technical details. isdemo seeks clarification, asking if vote timestamps and counts (e.g., “1/9/2017 12:25: 0 ‘yes’, 0 ‘no’, 1 ‘I dont know’”) can be retrieved. pfaffman explains that the Data Explorer plugin is required to run SQL queries for this data. isdemo confirms understanding but asks if there’s a ready-made plugin — pfaffman and dax clarify that manual query execution is needed, though results can be exported as CSV without copy-pasting. isdemo inquires about displaying this data publicly for all polls on their site, wondering if a plugin exists or if custom development is required. dax suggests using tablesgenerator.com to convert CSV results into Markdown tables for easy posting in topics, noting Discourse supports Markdown tables — implying no built-in plugin currently automates this for end users.

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

  • yes
  • no
  • I dont know
  • other
0 voters

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:

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.

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.