Get list of invited users

[pfaffman (Jay Pfaffman)]

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 thought that perhaps clicking “invited users” on the admin user page would do that, but it includes just my invites, not all invites.

Is there a way to do this? (Other than data explorer?)

[codinghorror (Jeff Atwood)]

This is a question for @techAPJ

[techAPJ (Arpit Jalan)]

@pfaffman

Is there a way to do this? (Other than data explorer?)

What’s the issue with using data explorer? A simple data explorer query for this will list all the invited users in properly formatted (hyperlinked) UI and the result can be exported as needed.

Here is the data explorer query if you are interested:

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

[pfaffman (Jay Pfaffman)]

I’d already written a query for data explorer, I was just surprised that there wasn’t a way to do it without the data explorer. Since invites are in their own table, it’s not rocket science to write the query, but your query taught me that I could append _user_id to something to make it use the user displayer thing. That’s cool. Thanks.

[techAPJ (Arpit Jalan)]

@pfaffman

Because required custom fields are not required for invites

Not anymore.

https://github.com/discourse/discourse/commit/b9c94aa234fb6198a163ca2e990a3e0b209fbf90

Demo:

[jimkleiber]

请注意，这个好像不再起作用了，但是下面的那个对我来说是有效的：

https://meta.discourse.org/t/list-of-users-who-signed-up-via-invitations/224871/6

@JammyDodger

我的 SQL 技能还有点生疏，但可以试试这个，看看我是否正确地进行了查找：

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 = u1.id
JOIN users u2 ON i.invited_by_id = u2.id
WHERE iu.redeemed_at IS NOT NULL
ORDER BY iu.redeemed_at DESC