RolesAssignments
List assignments for a role.
Table-Specific Information
SELECT
The provider uses the Pipedrive API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client-side within the provider.
| Column | Supported Operators |
| Id | = |
For example, the following queries are processed server-side:
SELECT * FROM RolesAssignments
SELECT * FROM RolesAssignments WHERE Id = 1
INSERT
Execute INSERT by specifying the Id and UserId columns. You can also insert any columns that are not required.
For example:
INSERT INTO RoleAssignments (Id, UserId, RoleId) VALUES (1, 'NameCdataIndia', '1')
DELETE
Execute DELETE by specifying the Id and UserId WHERE clause.
For example:
DELETE FROM RolesAssignments WHERE Id = 1 AND UserId = 1
Columns
| Name | Type | ReadOnly | References | Description |
| RoleId | Integer | False |
The ID of the role whose assignments are being listed. | |
| ActiveFlag | Boolean | True |
Whether the role assignment is currently active. | |
| Name | String | True |
The display name of the role. | |
| ParentRoleId | String | True |
The ID of the parent role in the role hierarchy, if applicable. | |
| Type | String | True |
The type of the assignment, indicating what kind of entity is assigned to this role. | |
| UserId | Integer | False |
ID of the user. |