UserDepartments
Gets information of Departments that a User belongs to, and Job Title information related to the Department.
Select
The UserCode column is required in the WHERE clause. The connector will use the Kintone APIs to filter the results by this column. By default, the connector will process other filters client-side within the connector.
For example, the following queries are processed server side:
SELECT * FROM UserDepartments where UserCode = 'loginname';
Columns
| Name | Type | References | Description |
| OrganizationId [KEY] | Long | The ID of the Department. | |
| TitleId [KEY] | Long | The ID of the Job Title. | |
| OrganizationCode | String | The Code of the Department. | |
| OrganizationName | String | The display name of the Department. | |
| OrganizationLocalName | String | The localized name of the Department. | |
| OrganizationLocalNameLocale | String | The locale of the localized name of the Department. | |
| OrganizationParentCode | String | The code of the Parent Department. null, if the parent is the Root. | |
| OrganizationDescription | Longvarchar | The description of the Department. | |
| TitleCode | String | The code of the Job Title. | |
| TitleName | String | The name of the Job Title. | |
| TitleDescription | Longvarchar | The description 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 | The log in name of the User. |