StateAttributeOptions
Lists the selectable states available for State attributes, representing various predefined states.
View-Specific Information
Select
Note that without filtering on TableName, the connector returns the results for the first table found.
The following examples show how to query the view for a specific table or list of tables:
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. |