Who closed the poll?

Support
1

Hi there!

When creating a poll on discourse it appears that any moderator/admin has the option to close the poll. I tried to find out using the Data Explorer plugin if we can figure out ‘who closed a specific poll?’ but none of the poll tables seem to record that. I also looked at staff log and I can’t find that either.

Do you know if it is possible to be able to figure out which user closed a poll in the forum?

Thanks!

3

If you using the Data Explorer you can try with this (SQL)

SELECT 
    pr.created_at AS "Closed At",
    p.topic_id AS "Topic ID",
    p.post_number AS "Post Number",
    u.username AS "Closed By",
    pr.modifications AS "Modifications"
FROM post_revisions pr
JOIN posts p ON p.id = pr.post_id
JOIN users u ON u.id = pr.user_id
WHERE pr.modifications LIKE '%status=closed%'
ORDER BY pr.created_at DESC
4

Hi

Thanks! I don’t think closing the poll is included in ‘post revisions’, are you sure? I tried and the closing/opening of a poll doesn’t appear there.

5

Thanks for the report @gassim :+1: I’ve added support for

  1. showing who closed a poll in the poll directly
  2. storing & logging who closed the poll for audit purposes