UserOrganizations
Query the organizations for a user.
Table Specific Information
Select
To get a list of organizations for a user, the UserId column is required. It can be set in the connection string or in the WHERE clause condition. Otherwise, the component will automatically use the Id of the first user from the Users table.
For example, the following query is processed server side by the Google Directory APIs:
SELECT * FROM UserOrganizations
Columns
Name | Type | Description |
Name | String | The name of the organization. |
UserId | String | The unique identifier for the user. |
OrganizationDomain | String | The domain the organization belongs to. |
Department | String | Specifies the department within the organization. |
Description | String | The description of the organization. |
Title | String | The user's title within the organization. |
CostCenter | String | The cost center of the user's organization. |
Location | String | The physical location of the organization. |
IsPrimary | Boolean | Indicates if this is the user's primary organization. |
Symbol | String | Text string symbol of the organization. |
Type | String | Country in the address. |
CustomType | String | If the value of type is custom, this property contains the custom type. |