Filter by text, not value

[Bertha]

I am using editor and template to display column as text.  But the actual values of the column is integer.  When doing filter on this column, I want to use text.

I am using the Grid Filtering with Dynamic Default Values to achieve that.  But I want the operators only show "Starts with", not "equal to" and only 1 operator (no need for "AND".  How can I achieve that?

var divData = [{ "value": 1, "text": "Owned" }, { "value": 2, "text": "Managed" }];

{ field: "DivisionID", title: "Division", values: divData, attributes: { style: "text-align:left" }, width: "150px", editor: divDropDownEditor, template: "#=getDivName(DivisionID)#" },

Thanks.

[Eyup]

Hi Bertha,

You can use filter customization to achieve this requirement:
https://demos.telerik.com/kendo-ui/grid/filter-menu-customization

And check the City column in this dojo sample:
https://dojo.telerik.com/uREFIrOP/2

The dataValueField of the combo is set to the "text" field of the source.

I hope this will prove helpful.

Regards,
Eyup
Progress Telerik

[Bertha]

Your City column is type: "string".  But my City column is type: "number".  I have a table called City with ID: as number, CityName as string.  So, in grid, that City column is storing CityID, not CityName.

Can you show me an example with City as number?  Thanks.

[Eyup]

Hi Bertha,

Here is the sample modified to filter numeric values:
https://dojo.telerik.com/uREFIrOP/5

The name of the column is Freight.

Regards,
Eyup
Progress Telerik