XF 1.1 Search for All Vote Poll Threads?

[DRE]

How do I find all the vote poll threads?

 

[Chris D]

If you're talking about some sort of front end search - unfortunately there isn't one.

However, I just wrote this query which might help if you run in PHP My Admin

SELECT xf_thread.title, xf_thread.thread_id, xf_poll.question
FROM xf_thread, xf_poll
WHERE xf_thread.thread_id = xf_poll.content_id

Returns every thread that contains a poll with the thread title, thread ID and poll question.

 

[DRE]

If you're talking about some sort of front end search - unfortunately there isn't one.

However, I just wrote this query which might help if you run in PHP My Admin

SELECT xf_thread.title, xf_thread.thread_id, xf_poll.question
FROM xf_thread, xf_poll
WHERE xf_thread.thread_id = xf_poll.content_id

Returns every thread that contains a poll with the thread title, thread ID and poll question.

View attachment 34376

THAANKS!!!!! *gives me new thread idea*