# LIST INVITATIONS

## Syntax <a href="#synopsis" id="synopsis"></a>

```sql
[ LIST | SHOW ] [ MY | PENDING ] INVITATIONS;
```

## Description <a href="#description" id="description"></a>

This command provides a list of [#organiation](https://docs.deltastream.io/overview/core-concepts/access-control#organiation "mention") invitations for the current user or organization using the `MY` and `PENDING` keywords, respectively.

`PENDING` invitations are listed only if current [#role](https://docs.deltastream.io/overview/core-concepts/access-control#role "mention") has [`MANAGE_MEMBERS`](https://docs.deltastream.io/overview/core-concepts/access-control#privilege) privileges.

## Examples

#### List pending invitations for the current organization

```sh
demodb.public/demostore# LIST PENDING INVITATIONS;
+--------------------------------------+------------+-------------------------+-----------------------------+---------------------+---------------+-------------------------------+-------------------------------+
|  ID                                  |  Org Name  |  Email Address          |  Invited By                 |  User Roles         |  Default Role |  Created At                   |  Updated At                   |
+======================================+============+=========================+=============================+=====================+===============+===============================+===============================+
| 9439f004-a7e6-40f1-a6c9-d781777d17fc | test       | member_2@deltastream.io | team_manager@deltastream.io | useradmin, sysadmin | useradmin     | 2024-05-13 20:44:58 +0000 UTC | 2024-05-13 20:44:58 +0000 UTC |
+--------------------------------------+------------+-------------------------+-----------------------------+---------------------+---------------+-------------------------------+-------------------------------+
```

#### List organization invitations for the current user

```sh
<no-organization># LIST MY INVITATIONS;
+--------------------------------------+------------+----------------------------------+
|  ID                                  |  Org Name  |  Invited By                      |
+======================================+============+==================================+
| f4bf44f1-2f5a-41ea-96fd-b1f7dc4c6e93 | test       | team_manager@deltastream.io      |
+--------------------------------------+------------+----------------------------------+
```