Need data explorer query to export an entire topic

Data & reporting
1

I need a working data explorer query to export a whole topic, can someone help. Much appreciated.

2

Hi @Mr.X_Mr.X :wave:

This should work, just specify the topic id parameter:

-- [params]
-- int :topic_id = 

select 
  p.id as post_id, 
  p.user_id, 
  p.created_at, 
  p.updated_at, 
  p.like_count, 
  p.raw as post_content 
from 
  posts p 
where 
  p.topic_id = :topic_id
3 Likes
3

Depending on afar they want with the data, they might want p.cooked.

3 Likes