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