Where does the polls data live? Can it be exported for offline processing?


(Tobias Eigen) #1

Hey all - we’ve been digging a bit into the polls in my community and there is interest, but there is also interest in exploring how far we can take it and whether we should be considering using it instead of external survey tools.

I was looking via the data explorer and not finding anything related to the polls - can someone show me which tables to look in? Has anyone else tried exporting poll data and gotten e.g. a csv export with poll details like username and email address of who voted, the option they chose and when they voted (including when they changed their vote, if they changed their vote)?

Thanks!


(Jeff Atwood) #2

Not sure where that is installed – @zogstrip?


(Régis Hanol) #3

Polls data is stored in the post_custom_fields table.

You have to look for

  • post_custom_fields.name == "polls" for all the data related to the polls associated to that post.
  • post_custom_fields.name LIKE "polls-votes-%" for all the data related to the votes of users on the polls of that post (that’s a mouthful)

(Gerhard Schlager) #4

This might help: