UsersPermissions
Lists the followers of a specific user.
Select
The add-in will use the Pipedrive API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the add-in.
- UserId supports the '=' operator.
For example, the following query is processed server side:
SELECT * FROM UsersPermissions WHERE UserId = 13822542
Columns
| Name | Type | References | Description |
| UserId | Integer | ID of the user. | |
| CanAddCustomFields | Boolean | CanAddCustomFields. | |
| CanBulkEditItems | Boolean | CanBulkEditItems. | |
| CanChangeVisibilityOfItems | Boolean | CanChangeVisibilityOfItems. | |
| CanCreateOwnWorkflow | Boolean | CanCreateOwnWorkflow. | |
| CanModifyOwnerForDeals | Boolean | CanModifyOwnerForDeals. | |
| CanDeleteDeals | Boolean | CanDeleteDeals. | |
| CanConvertDealsToLeads | Boolean | CanConvertDealsToLeads. | |
| CanMergeDeals | Boolean | CanMergeDeals. | |
| CanEditDealsClosedDate | Boolean | CanEditDealsClosedDate. | |
| CanModifyOwnerForLeads | Boolean | CanModifyOwnerForLeads. | |
| CanDeleteLeads | Boolean | CanDeleteLeads. | |
| CanMergeLeads | Boolean | CanMergeLeads. | |
| CanSeeDealsListSummary | Boolean | CanSeeDealsListSummary. | |
| CanAddDeals | Boolean | CanAddDeals. | |
| CanEditOtherUsersDeals | Boolean | CanEditOtherUsersDeals. | |
| CanAddLeads | Boolean | CanAddLeads. | |
| CanEditOtherUsersLeads | Boolean | CanEditOtherUsersLeads. | |
| CanEditCustomFields | Boolean | CanEditCustomFields. | |
| CanDeleteCustomFields | Boolean | CanDeleteCustomFields. | |
| CanUseImport | Boolean | CanUseImport. | |
| CanModifyLabels | Boolean | CanModifyLabels. | |
| CanExportDataFromLists | Boolean | CanExportDataFromLists. | |
| CanShareFilters | Boolean | CanShareFilters. | |
| CanEditSharedFilters | Boolean | CanEditSharedFilters. | |
| CanShareInsights | Boolean | CanShareInsights. | |
| CanUseEmailTracking | Boolean | CanUseEmailTracking. | |
| CanSeeOtherUsersStatistics | Boolean | CanSeeOtherUsersStatistics. | |
| CanSeeCompanyWideStatistics | Boolean | CanSeeCompanyWideStatistics. | |
| CanSeeOtherUsers | Boolean | CanSeeOtherUsers. | |
| CanFollowOtherUsers | Boolean | CanFollowOtherUsers. | |
| CanSeeHiddenItemsNames | Boolean | CanSeeHiddenItemsNames. | |
| CanModifyOwnerForActivities | Boolean | CanModifyOwnerForActivities. | |
| CanDeleteActivities | Boolean | CanDeleteActivities. | |
| CanModifyOwnerForPeople | Boolean | CanModifyOwnerForPeople. | |
| CanDeletePeople | Boolean | CanDeletePeople. | |
| CanMergePeople | Boolean | CanMergePeople. | |
| CanModifyOwnerForOrganizations | Boolean | CanModifyOwnerForOrganizations. | |
| CanDeleteOrganizations | Boolean | CanDeleteOrganizations. | |
| CanMergeOrganizations | Boolean | CanMergeOrganizations. | |
| CanAddProducts | Boolean | CanAddProducts. | |
| CanEditOtherUsersProducts | Boolean | CanEditOtherUsersProducts. | |
| CanModifyOwnerForProducts | Boolean | CanModifyOwnerForProducts. | |
| CanDeleteProducts | Boolean | CanDeleteProducts. | |
| CanDeleteProductVariations | Boolean | CanDeleteProductVariations. | |
| CanUseApi | Boolean | CanUseApi. | |
| CanAddPeople | Boolean | CanAddPeople. | |
| CanEditOtherUsersPeople | Boolean | CanEditOtherUsersPeople. | |
| CanAddOrganizations | Boolean | CanAddOrganizations. | |
| CanEditOtherUsersOrganizations | Boolean | CanEditOtherUsersOrganizations. |