Lists chat metadata for compliance review. Use the DeleteChat stored procedure for permanent deletion.

View-Specific Information

Select

Omitting UserId performs an organization-wide query. The API permits ProjectId filtering only with UserId. For an organization-wide query, the connector retrieves the permitted result set and evaluates ProjectId client-side. The connector splits UserId IN lists larger than the API maximum of 10 into batches. Because the API does not provide a single-chat read endpoint, the connector also evaluates Id filters client-side.

The API permits one time-filter family per request and requires it to match order_by. When both CreatedAt and UpdatedAt appear in a query, the connector sends the family matching an ascending timestamp ORDER BY, or CreatedAt when there is no matching order, and evaluates the other time filter client-side. With UserId, UpdatedAt filters are always client-side because updated_at is organization-wide only. If SQL ordering cannot be represented by the API, including a different timestamp, descending, or multi-column order, the connector orders the complete filtered result client-side before applying LIMIT or OFFSET.

The connector 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 connector.

Column	Supported Operators
UserId, OrganizationId, OrganizationUuid	=, IN
ProjectId	=
CreatedAt, UpdatedAt	>, >=, <, <=

• LIMIT

An ascending single-column ORDER BY CreatedAt or ORDER BY UpdatedAt is processed server-side only when it matches the selected API time family. Other ordering is processed client-side within the connector.

	SELECT Id, Name FROM Chats WHERE UserId = 'user_123' AND CreatedAt >= '2026-01-01T00:00:00Z' LIMIT 100;
	SELECT Id, ProjectId FROM Chats WHERE UserId IN ('user_123', 'user_456') AND ProjectId = 'claude_proj_123' LIMIT 100;
	SELECT Id, ProjectId FROM Chats WHERE ProjectId = 'claude_proj_123';
	SELECT Id, UpdatedAt FROM Chats WHERE UpdatedAt >= '2026-01-01T00:00:00Z' ORDER BY UpdatedAt LIMIT 100;
	SELECT Id FROM Chats WHERE UpdatedAt >= '2026-01-01T00:00:00Z' ORDER BY CreatedAt;
	SELECT Id FROM Chats WHERE CreatedAt >= '2026-01-01T00:00:00Z' AND UpdatedAt < '2026-02-01T00:00:00Z';
	SELECT Id, UpdatedAt FROM Chats WHERE UserId = 'user_123' AND UpdatedAt >= '2026-01-01T00:00:00Z';

Columns

Name	Type	Description
Id [KEY]	String	The unique identifier of the chat.
Name	String	The title of the chat.
CreatedAt	Datetime	The creation timestamp. Its range filters are sent when CreatedAt is the selected Chats time filter; otherwise they are evaluated client-side.
UpdatedAt	Datetime	The last-updated timestamp. Its range filters are sent only for organization-wide queries when UpdatedAt is the selected Chats time filter; otherwise they are evaluated client-side.
DeletedAt	Datetime	The deletion timestamp, when the chat has been deleted.
OrganizationId	String	The deprecated tagged organization Id. Filterable via organization_ids.
OrganizationUuid	String	The organization UUID. Filterable via organization_ids.
ProjectId	String	The project Id. project_ids is sent with UserId; organization-wide ProjectId filters are evaluated client-side.
Model	String	The model used in the chat; null for some legacy chats.
UserId	String	The owning user Id. Omit for an organization-wide query; IN lists are batched at 10 ids per request.
UserEmailAddress	String	The email address of the owning user.
Href	String	The web URL of the chat.