We are trying to boost our event attendance by finding users who have engaged with similar existing content. With the help of the AI bot, we were able to concoct the following query. -- [params] -- text :keyword -- int :min_engagements -- null string :tag_name WITH keyword_posts AS ( SELECT …

I think you’re going to want to use the discourse_post_event_events and discourse_post_event_invitees tables for this.

I was able to plug away at the following with the bot, but it is returning 0 results (even though I can see 30+ people have responded. The query works if I remove the WHERE statement. [صورة] Deploying the BeyondTrust Password Safe Connector for IdentityIQ with Michel... …

How about something like this: -- [params] -- text :keyword -- int :min_engagements -- null string :tag_name -- post_id :event_post WITH keyword_posts AS ( SELECT p.id AS post_id FROM posts p JOIN topics t ON t.id = p.topic_id LEFT JOIN topic_tags tt ON tt.topic_i…

سحب قائمة RSVP لحدث Pull عبر Data Explorer

مجتمع البيانات والتقارير

JammyDodger 23 أغسطس 2024، 6:37م 2

أعتقد أنك سترغب في استخدام جدولي discourse_post_event_events و discourse_post_event_invitees لهذا الغرض.

الموضوع		الردود	مرات العرض
Listing event invitees with email addresses Data & reporting events , sql-query	0	112	23 مارس 2026
Event organizing in Discourse Support	2	2362	1 أكتوبر 2018
Calendar RSVP Posts Plugin events	13	648	7 أكتوبر 2026
Export event data is a bit painful, and email addresses would be useful UX events	5	666	11 أغسطس 2025
Data explorer query for events? Data & reporting events , sql-query	4	475	23 يوليو 2023

سحب قائمة RSVP لحدث Pull عبر Data Explorer

الموضوعات ذات الصلة