UserDepartments

Returns the departments a user belongs to along with related job title information, supporting organizational mapping and identity management.

Select

WHERE 句では、UserCode カラムが必須です。本製品はKintone API を使用してこのカラムによる結果をフィルタリングします。デフォルトでは、本製品はクライアント側で本製品内で他のフィルタを処理します。

例えば、次のクエリはサーバー側で処理されます。

SELECT * FROM UserDepartments where UserCode = 'loginname';


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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
UserCode	String		Login name associated with the user, used to identify the user when querying related records.