Hi all! Is there a way to check the list of users who signed up to our forum via invitations? Thanks!

Do you have access to data explorer ? If so, you could try this: [صورة] Get list of invited users Feature Because required custom fields are not required for invites , a client wants to know who’s been invited. I don’t see an easy way to get that information. I…

I used this script in the data explorer , but it seems like an older script and did not give me any results after 2020. SELECT user_id, invited_by_id as invited_by_user_id, redeemed_at FROM invites WHERE redeemed_at IS NOT NULL ORDER BY redeemed_at DESC

I think the invite table was split at some point. Try this one and see if it works for the newer info: SELECT iu.user_id, i.invited_by_id AS invited_by_user_id, iu.redeemed_at AS reltime$time FROM invited_users iu JOIN invites i ON iu.invite_id = i.id WHERE iu.redeemed_at IS NOT NU…

This totally worked! I just wish the CSV file that I exported would show names/usernames instead of user IDs. Any way to do that? And thanks so much! :wink:

My SQL skills are still a little fledgling, but try this one and see if I’ve got the look-ups working properly: :slight_smile: SELECT u1.username AS invitee, u2.username AS inviter, iu.redeemed_at FROM invited_users iu JOIN invites i ON iu.invite_id = i.id JOIN users u1 ON iu.user_id…

I tested this and it works! Nice one. :sunflower: Another query that might be useful is the pending invites. Admins might like to know what their users are up to with the invitation system. This query however provides potentially valuable information for community building. I wonder if it could be…

I was able to update this data explorer query to include the invite_key used by the user to join the site. SELECT u1.username AS invitee, u2.username AS inviter, i.invite_key, iu.redeemed_at FROM invited_users iu JOIN invites i ON iu.invite_id = i.id JOIN users u1 ON iu.user_i…

استخدم Data Explorer للحصول على قائمة المستخدمين الذين سجلوا عبر الدعوات

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

tobiaseigen (Tobias Eigen) 20 أبريل 2022، 10:11م 2

هل لديك إمكانية الوصول إلى مستكشف البيانات؟ إذا كان الأمر كذلك، يمكنك تجربة هذا:

الموضوع		الردود	مرات العرض
Get list of invited users Feature invites	5	1531	2 ديسمبر 2023
How can Data Explorer list invited user link url Support data-explorer , invites	2	94	19 نوفمبر 2024
Who was this user invited by feature? Feature	4	1048	2 فبراير 2016
Show all current invites in admin Feature invites	0	432	28 يونيو 2020
Seeing invited users Support	2	548	16 مايو 2019

استخدم Data Explorer للحصول على قائمة المستخدمين الذين سجلوا عبر الدعوات

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