[Solved] Dropdown List in Filter Row to Filter Distinct Values

[Aaron Cross]

Hello,

I have a requirement to provide a drop down menu which contains distinct values for that particular column.

Is there a cell template I can get access to to override the functionality in the filter row?

Regards,

Aaron

[Nikolay]

Hi Aaron Cross,

You can make a stored procedure (or an in-code implementation) which prepares a datasource of distinct values and then assign this DataSource to the GridViewComboBoxColumn. Both the filter combo and the combo editor of the data cells will show a dropdown list of distinct values.

If you have additional questions, feel free to contact me.

Best wishes,
Nikolay
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.

[Aaron Cross]

Hello,

I think i've worded this question quite poorly.

In the standard telerik data grid you can enable a filter row, which allows you to type a filter in the column.  I want to replace the free text filter cell with a drop down list.

Is it possible to get access to the filter row in code so i can change it's behaviour?

Aaron

[Nikolay]

Hello Aaron Cross,

Thank you for the additional details.

They helped me to understand your requirement. You can replace the default filter editor by handling the EditorRequired event as it is demonstrated in this help article. Additionally, you should add the items of interest in the CellEditorInitialized event handler. I am attaching a sample project which covers your scenario.

I hope this helps. If you have additional questions, feel free to contact me.

Sincerely yours,
Nikolay
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Watch a video on how to optimize your support resource searches and check out more tips on the blogs.