StateAttributeOptions
Lists the selectable states available for State attributes, representing various predefined states.
View-Specific Information
SELECT
The driver uses the Microsoft Dataverse API to process WHERE clause conditions built with the following column and its supported operators. All other filters are processed client-side.
- TableName supports = and IN operators.
TableName is required when querying this view.
For example, the following queries are processed server-side:
SELECT * FROM StateAttributeOptions WHERE TableName = 'AccountLeads'
SELECT * FROM StateAttributeOptions WHERE TableName IN ('Account', 'AccountLead')
Columns
| Name | Type | References | Description |
| ColumnName | String |
StateAttributeMetadata.ColumnName | The name of the column in the table where the state option is defined. |
| Color | String | The color code associated with the state option, often used for UI representation. | |
| ExternalValue | String | An external system value mapped to this state option, if applicable. | |
| HasChanged | String | Indicates whether the state option has been modified since its creation or last update. | |
| IsManaged | Boolean | Specifies if the state option is managed (part of a managed solution). | |
| Label_LocalizedLabels | String | Localized labels for the state option in various supported languages. | |
| Label_UserLocalizedLabel_HasChanged | String | Indicates if the user-customized label for the state option has been modified. | |
| Label_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized label for the state option is managed (part of a managed solution). | |
| Label_UserLocalizedLabel_Label | String | The user-customized label text for the state option. | |
| Label_UserLocalizedLabel_LanguageCode | Integer | The language code corresponding to the user-customized label. | |
| Label_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata associated with the user-customized label. | |
| Description_LocalizedLabels | String | Localized descriptions for the state option in various supported languages. | |
| Description_UserLocalizedLabel | String | The user-customized description for the state option, providing additional context or details. | |
| MetadataId | String | The unique identifier for the metadata associated with the state option. | |
| ParentValues | String | Specifies the parent values for hierarchical state options, if applicable. | |
| Value | Integer | The integer value associated with this state option, used for storage and retrieval. | |
| TableName | String | The name of the table where this state option is defined. |