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 component will use the Kintone APIs to filter the results by this column. By default, the component will process other filters client-side within the component.
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. |