UserDepartments
Returns the departments a user belongs to along with related job title information, supporting organizational mapping and identity management.
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 UserDepartments where UserCode = 'loginname';
Columns
| Name | Type | References | Description |
| OrganizationId [KEY] | Long | Unique identifier for the department, used to link department records to related organizational data. | |
| TitleId [KEY] | Long | Unique identifier for the job title, allowing you to associate users or roles with a specific title. | |
| OrganizationCode | String | Code assigned to the department, typically used for internal categorization or external system references. | |
| OrganizationName | String | Primary display name of the department as it appears in the organization's directory. | |
| OrganizationLocalName | String | Localized display name of the department for regions or languages that require a translated label. | |
| OrganizationLocalNameLocale | String | Locale code indicating the language or region associated with the department's localized name. | |
| OrganizationParentCode | String | Code of the department's parent unit to help model the organizational hierarchy. If the value is 'null', it indicates a root-level department. | |
| OrganizationDescription | Longvarchar | Text description that provides additional context about the department's responsibilities or purpose. | |
| TitleCode | String | Internal or external reference code assigned to the job title for classification or system integration. | |
| TitleName | String | Human-readable name of the job title used in employee profiles and organizational charts. | |
| TitleDescription | Longvarchar | Text description explaining the scope, responsibilities, or role of the job title. |
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 the user when querying related records. |