Finding poll name and post_id for an explorer query

Data & reporting
,
1

Where can I find the poll name if I don’t give it a name when I create a poll? Also, I assumed the post id is the topic id that contains the poll, is that correct?

1 Like
2

I’m afraid not - each post has its own ID. It used to be easy to see it by appending .json onto the link of the post in your browser address bar and hitting enter. However, this doesn’t seem to be the case any more as you get all the posts:

image

If you scroll down it you’ll eventually find the post of interest. The poll name should be in there too, but if not edit the post and you’ll see it in the markdown.

3 Likes
3

Thank you for the explanation! I will take a look.

2 Likes
4

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.

5

I made a little explorer query as a cheeky look-up a while back, though not sure if it’s any easier than the json method. :slight_smile: But here it is:

-- [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