This is a migrated thread and some comments may be shown as answers.

Filtering with SQL

1 Answer 232 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Gibran
Top achievements
Rank 1
Gibran asked on 08 Mar 2017, 06:32 PM
Hello,

I'm experimenting with the Kendo Grid's filtering API function. I'm wondering if the API has any functionality for taking in an SQL string for filtering, at least a WHERE clause. Something like the following:

        $('#kendoGrid').data('kendoGrid').dataSource.filter('WHERE status = N');

Thank you.

1 Answer, 1 is accepted

Sort by
0
Stefan
Telerik team
answered on 10 Mar 2017, 11:45 AM
Hello Gibran,

Currently, this is not supported as the filtering is applied to the Grids dataSource instance and it is not directly connected to an SQL database.

Please check the expected format of the filter method in our documentation:

http://docs.telerik.com/kendo-ui/api/javascript/data/datasource#methods-filter


Let me know if you need additional information on this matter.

Regards,
Stefan
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data (charts) and form elements.
Tags
Grid
Asked by
Gibran
Top achievements
Rank 1
Answers by
Stefan
Telerik team
Share this question
or