Poll: Export poll results in CSV for quiz creator?

Contribute Feature
11

The one it uses automatically is available in the data-explorer at /admin/plugins/explorer?id=-16 though it has post id (and poll name) as a parameter, so not that user-friendly, but possibly something to build on?

I’ve put together a simple poll look-up that works on topic_id and post_number (which is avaible in every post address). This should then give you the post_id and poll names for all the polls in that post. You can then feed that to the pre-existing poll query to run it manually without having look in the console or the json file to find out the info. :+1:

-- [params]
-- int :topic_id
-- int :post_number = 1

SELECT pl.post_id, 
       p.id,
       pl.name
FROM polls pl
JOIN posts p ON p.id = pl.post_id
WHERE p.topic_id = :topic_id
AND p.post_number = :post_number
3 Likes