Using DropDownList filter for a field in the Grid containing an array.

Environment

Description

I have a field in the Grid that contains an array. I want to add a DropDownList filter for that column that will filter the array values.

Solution

The first step is to create a custom filter with a DropDownList for the array column through the "filterCell" property of the column. The selected value from the DropDownList will be added to the filter expressions, but since there is no built-in operator that will search within an array field, a custom operator must be defined. Within the onDataStateChange event of the Grid, find and replace the filter operator for the array field.

Following is an example with the described approach: