StateAttributeMetadata
Provides metadata for attributes of type State, describing state-related fields used for status tracking or categorization.
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 StateAttributeMetaData WHERE TableName='AccountLeads'
SELECT * FROM StateAttributeMetaData WHERE TableName IN ('Account','AccountLead');
Columns
| Name | Type | References | Description |
| ColumnName [KEY] | String | The name of the column in the table where the state attribute is defined. | |
| MetadataId | String | The unique identifier for the metadata associated with this state attribute. | |
| OptionSet_Description_LocalizedLabels | String | Localized descriptions for the state options in various supported languages. | |
| OptionSet_Description_UserLocalizedLabel_HasChanged | String | Indicates whether the user-customized description label for the state options has been modified. | |
| OptionSet_Description_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized description label for the state options is managed (part of a managed solution). | |
| OptionSet_Description_UserLocalizedLabel_Label | String | The user-customized label text for the description of the state options. | |
| OptionSet_Description_UserLocalizedLabel_LanguageCode | Integer | The language code associated with the user-customized description label. | |
| OptionSet_Description_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-customized description label. | |
| OptionSet_DisplayName_LocalizedLabels | String | Localized display names for the state options in various supported languages. | |
| OptionSet_DisplayName_UserLocalizedLabel_HasChanged | String | Indicates whether the user-customized display name label for the state options has been modified. | |
| OptionSet_DisplayName_UserLocalizedLabel_IsManaged | Boolean | Specifies if the user-customized display name label for the state options is managed (part of a managed solution). | |
| OptionSet_DisplayName_UserLocalizedLabel_Label | String | The user-customized label text for the display name of the state options. | |
| OptionSet_DisplayName_UserLocalizedLabel_LanguageCode | Integer | The language code associated with the user-customized display name label. | |
| OptionSet_DisplayName_UserLocalizedLabel_MetadataId | String | The unique identifier for the metadata of the user-customized display name label. | |
| OptionSet_ExternalTypeName | String | The external type name associated with the state options, if applicable. | |
| OptionSet_HasChanged | String | Indicates whether the state option set has been modified since its creation or last update. | |
| OptionSet_IntroducedVersion | String | The version of the system in which the state option set was introduced. | |
| OptionSet_IsCustomizable_CanBeChanged | Boolean | Indicates whether the state option set can be customized by the user or administrators. | |
| OptionSet_IsCustomizable_ManagedPropertyLogicalName | String | The logical name of the managed property controlling the customizability of the state option set. | |
| OptionSet_IsCustomizable_Value | Boolean | Specifies if the state option set is customizable. | |
| OptionSet_IsCustomOptionSet | Boolean | Indicates whether the state option set is custom or part of a default configuration. | |
| OptionSet_IsGlobal | Boolean | Specifies if the state option set is global (shared across entities) or local (specific to one entity). | |
| OptionSet_IsManaged | Boolean | Indicates if the state option set is managed (part of a managed solution). | |
| OptionSet_MetadataId | String | The unique identifier for the metadata associated with the state option set. | |
| OptionSet_Name | String | The name of the state option set. | |
| OptionSet_OptionSetType | String | The type of the state option set (e.g., picklist, drop-down). | |
| OptionSet_ParentOptionSetName | String | The name of the parent option set, if this state option set is part of a hierarchy. | |
| TableName | String | The name of the table where this state attribute is defined. |