ClaudeChatDeleted
Returns only claude_chat_deleted activities.
View-Specific Information
Select
This view always requests the claude_chat_deleted activity type. Type is fixed and cannot be changed in the query.
The actor union is flattened into ActorType and nullable Actor* detail columns. Fields that do not apply to the row's actor variant are null.
The component 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 component.
The API processes supported ordering server-side. Unsupported ordering, grouping, and offsets are processed client-side within the component. Without an ORDER BY clause, the API returns results newest-first.
| Column | Supported Operators |
| ActorId, ActorUserId | =, IN |
| OrganizationId, OrganizationUuid | =, IN |
| CreatedAt | >, >=, <, <= |
- ORDER BY CreatedAt ASC or DESC
- LIMIT
SELECT Id, CreatedAt, ActorType, ActorUserId FROM ClaudeChatDeleted WHERE CreatedAt >= '2026-01-01T00:00:00Z' LIMIT 100;
SELECT * FROM ClaudeChatDeleted 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. |
| ActorEmailAddress | String | The email address for user_actor or anthropic_actor. |
| ActorUserId | String | The user Id for user_actor. Filterable through user_ids. |
| ActorApiKeyId | String | The API key Id for api_actor. |
| ActorAdminApiKeyId | String | The Admin API key Id for admin_api_key_actor. |
| ActorUnauthenticatedEmailAddress | String | The email address for unauthenticated_user_actor. |
| ActorService | String | The automated process name for system_actor. |
| ActorServiceAccountId | String | The service-account Id for service_account_actor. |
| ActorWorkosEventId | String | The WorkOS event Id for scim_directory_sync_actor. |
| ActorDirectoryId | String | The identity-provider directory Id for scim_directory_sync_actor. |
| ActorIdpConnectionType | String | The identity-provider connection type for scim_directory_sync_actor. |
| ActorIssuer | String | The verified OIDC issuer for federated_identity_actor. |
| ActorSubject | String | The verified OIDC subject for federated_identity_actor. |
| ActorAudience | String | The verified OIDC audience claims as JSON for federated_identity_actor. |
| ActorIpAddress | String | The source IP address for the actor variant. |
| ActorUserAgent | String | The source user agent for the actor variant. |
| Type | String | Always claude_chat_deleted. |
| ClaudeChatId | String | Deleted chat Id. |
| ClaudeProjectId | String | Associated project Id. |
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. |