UserGroups
Returns the groups associated with a user so you can understand their access rights and collaborative relationships across the system.
Select
The UserCode column is required in the WHERE clause. The add-in will use the Kintone APIs to filter the results by this column. By default, the add-in will process other filters client-side within the add-in.
For example, the following queries are processed server side:
SELECT * FROM UserGroups where UserCode = 'loginname';
Columns
| Name | Type | References | Description |
| GroupId [KEY] | Long | Unique identifier for the group, used to link the group to membership records and permission assignments. | |
| GroupCode | String | Internal reference code assigned to the group for classification or integration with external systems. | |
| GroupName | String | Display name of the group as it appears in user directories and access management tools. | |
| GroupDescription | Longvarchar | Text description that outlines the purpose, role, or membership characteristics of the group. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description | |
| UserCode | String | Login name associated with the user, used to identify which user belongs to the group when querying relationships. |