MagicLinkLoginFailed
Returns only magic_link_login_failed activities.
View-Specific Information
Select
This view always requests the magic_link_login_failed activity type. Type is fixed and cannot be changed in the query.
The actor is always an unauthenticated_user_actor. Its documented fields are flattened into ActorType, ActorUnauthenticatedEmailAddress, ActorIpAddress, and ActorUserAgent.
The driver uses the Claude Compliance API to process WHERE clause conditions built with the following columns and operators server-side. The rest of the filter is processed client-side within the driver.
The API processes supported ordering server-side. Unsupported ordering, grouping, and offsets are processed client-side within the driver. Without an ORDER BY clause, the API returns results newest-first.
| Column | Supported Operators |
| ActorId | =, IN |
| OrganizationId, OrganizationUuid | =, IN |
| CreatedAt | >, >=, <, <= |
- ORDER BY CreatedAt ASC or DESC
- LIMIT
SELECT Id, CreatedAt, ActorType, ActorUnauthenticatedEmailAddress FROM MagicLinkLoginFailed WHERE CreatedAt >= '2026-01-01T00:00:00Z' LIMIT 100;
SELECT * FROM MagicLinkLoginFailed WHERE OrganizationUuid = 'abcdef01-2345-6789-abcd-ef0123456789' AND ActorId = 'user_123' LIMIT 100;
Columns
| Name | Type | Description |
| Id [KEY] | String | The activity Id. |
| CreatedAt | Datetime | Activity time. Filterable with created_at ranges. |
| OrganizationId | String | Organization Id filterable via organization_ids. |
| OrganizationUuid | String | Organization UUID filterable via organization_ids. |
| ActorType | String | The actor union discriminator. |
| ActorUnauthenticatedEmailAddress | String | The email address for unauthenticated_user_actor. |
| ActorIpAddress | String | The source IP address for the actor variant. |
| ActorUserAgent | String | The source user agent for the actor variant. |
| Type | String | Always magic_link_login_failed. |
Pseudocolumns
Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.
| Name | Type | Description |
| ActorId | String | Filters with actor_ids. |