PersonFieldsOptions
Returns the selectable options for enum and set type person fields. Each row represents one option value available for a given person field.
View-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 |
| PersonFieldId | = |
For example, the following query is processed server-side:
SELECT * FROM PersonFieldsOptions WHERE PersonFieldId = 123
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | The unique identifier of the field option. | |
| Label | String | The display label shown to users when selecting this option in Pipedrive. | |
| PersonFieldId [KEY] | Integer |
PersonFields.Id | The ID of the parent person field that owns this option. |