# How can Data Explorer list invited user link url
**URL:** https://meta.discourse.org/t/how-can-data-explorer-list-invited-user-link-url/336861
**Category:** Support
**Tags:** data-explorer, invites
**Created:** [November 19, 2024, 3:00am UTC](https://meta.discourse.org/t/how-can-data-explorer-list-invited-user-link-url/336861 "2024-11-19T03:00:36Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Jun](https://meta.discourse.org/u/Jun)
#### Post date: [November 19, 2024, 3:00am UTC](https://meta.discourse.org/t/how-can-data-explorer-list-invited-user-link-url/336861/1 "2024-11-19T03:00:36Z")
I’ve created multiple links to invite users. When user invited, how to distinguish the specific link url user clicked?
---
### Author:  [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)
#### Post date: [November 19, 2024, 5:24pm UTC](https://meta.discourse.org/t/how-can-data-explorer-list-invited-user-link-url/336861/2 "2024-11-19T17:24:39Z")
That’s a good question. Looks like the pending invites page only displays how many times a given invite has been redeemed, and the redeemed page only shows the invited users and whether the invitation was sent via link or email.
A small product improvement could be to change the last column on the redeemed list so it displays the link code itself instead of simply link/email.
It would also be helpful if the first column on the pending list could be improved:
- show full invite code link instead of just the first four characters
- link to a filtered view of redeemed invites, showing just the members who that used that invite link code to join the site.
- when an invite is sent by email, still show the full invite link code and indicate if it was redeemed
The invite modal could also be improved:
- indicate next to “max uses” how many times an invite has already been redeemed, as a link to a filtered view of redeemed invites
- if an emailed invite has already been redeemed, indicate that it has already been redeemed with a link to a filtered view of redeemed invites
- if an emailed invite has already been redeemed, do not allow the update and update and send email to be submitted.
---
### Author:  [@tobiaseigen](https://meta.discourse.org/u/tobiaseigen)
#### Post date: [November 19, 2024, 5:40pm UTC](https://meta.discourse.org/t/how-can-data-explorer-list-invited-user-link-url/336861/3 "2024-11-19T17:40:14Z")
I just noticed that you are asking about [data explorer](https://meta.discourse.org/t/32566?silent=true). It certainly is possible to get this data that way - try using the query below.
> [@Use data explorer to get a list of users who signed up via invitations](https://meta.discourse.org/t/use-data-explorer-to-get-a-list-of-users-who-signed-up-via-invitations/224871/8):
>
> I was able to update this [data explorer](https://meta.discourse.org/t/32566?silent=true) query to include the `invite_key` used by the user to join the site.
>
> ```plaintext
> 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_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
>
> ```
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [December 19, 2024, 5:40pm UTC](https://meta.discourse.org/t/how-can-data-explorer-list-invited-user-link-url/336861/4 "2024-12-19T17:40:43Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.