Administration > OData Web Services > Using Filters in OData
  
Using Filters in OData
Filtering on an Enumeration
Filtering on enumerations is supported, but the OData specification requires values to be represented by their fully qualified names.
For example, given a single list attribute with a key name of status in the Color type and a locally declared enumeration, the service represents the enumeration as follows:
<ENUMTYPE NAME="COLOR_25_STATUS_25_ENUM" ISFLAGS="FALSE" UNDERLYINGTYPE="EDM.INT32">
<MEMBER NAME="ACTIVE"/>
<MEMBER NAME="INACTIVE"/>
</ENUMTYPE>
This declaration shows two possible values: active and inactive. To filter on an inactive status, the URL must have the fully qualified name which includes the namespace (RFA), the enumeration type, and the value in single quotes, each separated by dots.
<host>/Windchill/servlet/RFA-OData/Colors?$filter=RFA. Color_25_status_25_Enum.’inactive’
Filtering and Ordering on Complex Types and Collections
Filtering and ordering on complex type and collections is not supported. Attribute types include multi-list, multi-entry, and composite.