UserLocations
Query the locations for a user.
Table Specific Information
Select
To get a list of locations for a user, the UserId column is required. It can be set in the connection string or in the WHERE clause condition. Otherwise, the add-in 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 UserLocations
Columns
| Name | Type | Description |
| Area | String | Textual location of the user. |
| UserId | String | The unique identifier for the user. |
| BuildingId | String | The building identifier. |
| DeskCode | String | The desk location. |
| FloorName | String | The floor name/number |
| FloorSection | String | The floor section. |
| CustomType | String | The custom type of the location. |
| Type | String | The type of the location. |