I have tried querying something as simple as this, to start: SELECT * FROM discourse_post_event_invitees WHERE post_id = :post_id Unfortunately I’m getting 0 results back for a post that I know has 15 users marked as Going. Any ideas?

That should work. Are you grabbing the right post id from the json? I think you could link it up to the posts table and use a topic id, which may be less faff than finding the post id. Something like: -- [params] -- topic_id :topic_id SELECT ei.user_id, ei.status FROM discourse_post_event_invitee…

Okay, getting closer. That returns everyone who is going or interested, how do you differentiate?

Ah, okay, the name of the key “status” confused me a bit. I was thinking that was some sort of status of the event. status = 0 = Going status = 1 = Interested status = 2 = Not Going

You can make it a bit easier to read without remembering the codes too if you add in a little something like this: -- [params] -- topic_id :topic_id SELECT ei.user_id, CASE WHEN ei.status = 0 THEN 'Going' WHEN ei.status = 1 THEN 'Interested' WHEN ei.status = 2 THEN 'N…

イベント用のデータエクスプローラークエリ？

コミュニティデータとレポート

jordan-violet (Jordan Violet) 2023 年 7 月 23 日午後 1:43 4

ああ、なるほど、「status」というキーの名前が少し混乱しました。イベントのステータスのようなものだと思っていました。

status = 0 = 参加予定
status = 1 = 興味あり
status = 2 = 不参加

トピック		返信	表示
Listing event invitees with email addresses Data & reporting events , sql-query	0	119	2026 年 3 月 23 日
Pull Event RSVP list via Data Explorer Data & reporting events , sql-query	3	193	2024 年 8 月 23 日
Export event data is a bit painful, and email addresses would be useful UX events	5	675	2025 年 8 月 11 日
User-posted code blocks in a category Data & reporting sql-query	3	376	2024 年 5 月 13 日
Use data explorer to get a list of users who signed up via invitations Data & reporting data-explorer , invites	7	1190	2024 年 11 月 19 日

イベント用のデータエクスプローラー クエリ？

関連トピック

イベント用のデータエクスプローラークエリ？