Views
Views are composed of columns and pseudo columns. Views are similar to tables in the way that data is represented; however, views do not support updates. Entities that are represented as views are typically read-only entities. Often, a stored procedure is available to update the data if such functionality is applicable to the data source.
Queries can be executed against a view as if it were a normal table, and the data that comes back is similar in that regard.
Dynamic views, such as queries exposed as views, and views for looking up specific combinations of project_team work items are supported.
AzureActiveDirectory Adapter Views
Name | Description |
AdministrativeUnitMembers | Retrieves all AdministrativeUnitMembers for the authenticated user. |
AdministrativeUnits | Retrieves all AdministrativeUnits for the authenticated user. |
Contacts | Retrieves the Contacts for the organization. |
Contracts | Retrieves all contracts for the authenticated user. |
DeviceRegisteredOwners | DeviceRegisteredOwners table for Azure AD data provider. |
DeviceRegisteredUsers | DeviceRegisteredUsers table for Azure AD data provider. |
DirectoryAudits | Retrieves all directory audit items for the authenticated user. |
DirectoryRoleMembers | DirectoryRoleMembers table for Azure AD data provider. |
DirectoryRoles | Retrieves all DirectoryRoles for the authenticated user. |
DirectoryRoleTemplates | Retrieves all DirectoryRoleTemplates for the authenticated user. |
GroupApplicationRoleAssignments | GroupApplicationRoleAssignments table for Azure AD data provider. |
GroupMembers | GroupMembers table for Azure AD data provider. |
Organization | Retrieves the Organization for the authenticated user. |
RoleAssignments | Retrieves the Role Assignments for the Azure AD. |
RoleDefinitions | Retrieves the Role Definitions for the Azure AD. |
SignIns | Retrieves the user sign-ins for your tenant. |
UserApplicationRoleAssignments | UserApplicationRoleAssignments table for Azure AD data provider. |