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.

[изображение] 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: [изображение] 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! [изображение] 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…

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

Support

riking (Kane York) 28.Октябрь.2015 00:39:20 14

Default values are specified like this:

Тема		Ответов	Просм.
Is it possible to keep the votes history of a poll? Support	7	2911	02.09.2017
Remove the anonymity of poll Support	1	469	20.08.2020
Creating and managing polls Using Discourse polls , how-to	26	42950	22.09.2026
Poll problem - exact vote numbers needed Support polls	5	2831	24.08.2017
How could I get voters from a poll? Support polls	7	1243	26.02.2025

Is it possible to see who voted in polls?

Связанные темы