Lists the selectable states available for State attributes, representing various predefined states. Only available when Edition is set to CustomerService, FieldService, Marketing, ProjectOperations, or Sales.

View-Specific Information

SELECT

The driver uses the Microsoft Dynamics 365 API to process WHERE clause conditions built with the following column and operators. The rest of the filter is executed client-side within the driver.

• TableName supports the = and IN operators.

For example, the following queries are processed server-side:

SELECT * FROM StateAttributeOptions WHERE TableName = 'teams'

SELECT * FROM StateAttributeOptions WHERE TableName IN ('accounts', 'teams')

To query this view, you must include a value for the TableName filter.

Columns

Name	Type	Description
ColumnName	String	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.