ComplianceGroupMembers
Returns the members of compliance groups. Specify GroupId to query one group, or omit it to source group IDs from ComplianceGroups and query each group.
View-Specific Information
Select
If GroupId is omitted, the add-in can source group Ids from ComplianceGroups and query each group.
The add-in uses the Claude Compliance API to process WHERE clause conditions built with the following column and operator server-side. The rest of the filter, including sorting, grouping, and offsets, is processed client-side within the add-in.
- GroupId supports the following operator: =.
- LIMIT
SELECT UserId, Email FROM ComplianceGroupMembers WHERE GroupId = 'group_123' LIMIT 100;
Columns
| Name | Type | Description |
| UserId [KEY] | String | The identifier of the member user. |
| GroupId [KEY] | String | The identifier of the group. Filterable with =. Obtain it from ComplianceGroups.Id to query one group; when omitted, the provider queries each group. The provider copies the SQL criterion into each row because the response does not repeat the parent group Id. |
| String | The email address of the member. | |
| CreatedAt | Datetime | The timestamp at which the member was added. |
| UpdatedAt | Datetime | The last-updated timestamp of the membership. |