RolesSetting

Returns all the roles settings.

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
RoleId	=

For example, the following queries are processed server-side:

SELECT * FROM RolesSetting

SELECT * FROM RolesSetting WHERE RoleId = 1

INSERT

Execute INSERT by specifying the Name and FieldType columns. You can also insert any columns that are not required. For example:

INSERT INTO RolesSetting (RoleId, SettingKey, Value) VALUES (1, 'deal_default_visibility', '1')

UPDATE

Execute UPDATE by setting values for SettingKey and Value and specifying RoleId in the WHERE clause. All columns that are not read-only can be updated. For example:

UPDATE RolesSetting SET Value = '3', SettingKey = 'deal_default_visibility' WHERE RoleId = 1

Columns


Name	Type	ReadOnly	References	Description
RoleId [KEY]	Integer	False		The ID of the role whose visibility settings are being retrieved.
DealDefaultVisibility	Integer	True		The default visibility setting applied to deals created by users in this role.
LeadDefaultVisibility	Integer	True		The default visibility setting applied to leads created by users in this role.
OrgDefaultVisibility	Integer	True		The default visibility setting applied to organizations created by users in this role.
PersonDefaultVisibility	Integer	True		The default visibility setting applied to persons created by users in this role.
ProductDefaultVisibility	Integer	True		The default visibility setting applied to products created by users in this role.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.


Name	Type	Description
Value	String	Possible values for the default_visibility setting depending on the subscription plan. The allowed values are 1, 3, 5, 7.
SettingKey	String	SettingKey. The allowed values are deal_default_visibility, lead_default_visibility, org_default_visibility, person_default_visibility, product_default_visibility.