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.
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
0
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
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.