I just tested out polls for the first time in a while, and it works quite well and I like it. But I would like to have an open poll so we can see who voted for which option. Is this possible? Is there any way to see who voted for what?

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…

it works! thanks so much. :fireworks: is there a query for quickly identifying the post ID containing polls? I used the .json URL method but it was surprisingly cumbersome to find the right post within it.

[image] gerhard: I added a second parameter for the poll name which usually is poll ( @riking default values for params would be a nice feature :wink:) Default values are specified like this: [image] gerhard: – text :poll_name = poll

I updated the query. It’s now a lot simpler. :slight_smile:

Is there a way to filter out the results based in account age? For example, if an account is less than 60days old it would not show in the results? Or perhaps there is a way to build a poll that limits who can vote based on account age? We are trying to prevent possible ballot stuffing by newly cr…

That is a very interesting use case. I do think we should have an option to prevent TL0 users from voting in a poll @zogstrip !

Is there a parameter that I could add to the search string by @gerhard that would not show the users below a certain trust level or account age in the query? Even if I had to manually tally votes based on the results it would be faster than having to manually check every accounts age and thier vote…

Here’s a query to set a minimal trust level for the users. -- [params] -- post_id :post_id -- text :poll_name = poll -- integer :min_trust_level 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) …

Awesome :heart_eyes: @gerhard thank you!

Note that this query is now included in the stock Data Explorer queries that are automatically installed, so you don’t need to enter this code yourself! [image] gerhard: How to find post_id Another way to find the post ID, especially if it’s the first post is to look at <topic_url>.json (e.g.…

@nbianca can you add to your list to add a new poll parameter min_trust_level that will allow polls creator to restrict who can vote based on their trust level? The option should be available in the poll builder UI and there should be a nice message explaining why some users can’t vote on that poll…

Is it possible to see who voted in polls?

Soutien

riking (Kane York) Octobre 28, 2015, 12:39 14

Default values are specified like this:

4 « J'aime »

Sujet		Réponses	Vues
Is it possible to keep the votes history of a poll? Support	8	2795	Avril 24, 2020
Remove the anonymity of poll Support	1	419	Août 20, 2020
Creating and managing polls Using Discourse how-to , polls	25	41390	Mars 3, 2026
Poll problem - exact vote numbers needed Support polls	6	2717	Juin 8, 2024
How could I get voters from a poll? Support polls	7	1118	Février 26, 2025

Is it possible to see who voted in polls?

Sujets connexes