StatusAttributeOptions
Defines the set of statuses that can be assigned to Status attributes, supporting status-driven workflows.
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 StatusAttributesOptions WHERE TableName='AccountLeads'
SELECT * FROM StatusAttributesOptions WHERE TableName IN ('Account','AccountLead');
Columns
| Name | Type | References | Description |
| ColumnName | String |
StatusAttributeMetadata.ColumnName | The name of the column in the table where the status option is defined. |
| Color | String | The color code associated with the status option, typically used for visual representation in user interfaces. | |
| ExternalValue | String | An external system value mapped to this status option, if applicable. | |
| HasChanged | String | Indicates whether the status option has been modified since its creation or last update. | |
| IsManaged | Boolean | Specifies if the status option is managed (part of a managed solution). | |
| Label_LocalizedLabels | String | Localized labels for the status option in various supported languages. | |
| Label_UserLocalizedLabel_HasChanged | String | Indicates if the user-customized label for the status option has been modified. | |
| Label_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized label for the status option is managed (part of a managed solution). | |
| Label_UserLocalizedLabel_Label | String | The user-customized label text for the status 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 status option in various supported languages. | |
| Description_UserLocalizedLabel | String | The user-customized description for the status option, providing additional context or details. | |
| MetadataId | String | The unique identifier for the metadata associated with the status option. | |
| ParentValues | String | Specifies the parent values for hierarchical status options, if applicable. | |
| Value | Integer | The integer value associated with this status option, used for storage and retrieval. | |
| TableName | String | The name of the table where this status option is defined. |