How to do a Full Text Search filter

[Meerkat]

Hello I have searched everywhere I can think of and cannot find any guidance on how to do a Full Text Search Filter.
I need to filter on ANY Word, ALL Words or EXACT phrase selected from a combo box.
Your built in filter thing is impractical for 90% of all my filter needs so I have to create my own filters using $filter.push 
One of the fields in my database ( which is obviously not displayed in the grid) contains many thousands of words, so a normal
$filter.push({ field: "Chapter", operator: "contains", value: $SearchString });
would be unsuitable

Please can you help me find the relevant documentation on how to filter with Full Text Search on a field that does not appear in the grid.
If FTS is not possible, would you suggest that I forget about using an MVC wrapper and try learning  about your basic Kendo UI ( or whatever you call it)

Many thanks.

[Atanas Korchev]

Hello Pete,

Indeed Kendo UI grid for ASP.NET MVC doesn't support full text filtering out of the box. You can perhaps support that by implementing custom binding. Documentation about custom binding is available here: http://docs.kendoui.com/getting-started/using-kendo-with/aspnet-mvc/helpers/grid/custom-binding

You  need to take the filter expression from the DataSourceRequest parameter of the action method and execute the corresponding DB call to perform the full text search.

 If you decide not to use Kendo UI grid for ASP.NET MVC you could check this example which shows how to bind the JavaScript version of the grid to ASP.NET MVC controller: https://github.com/telerik/kendo-examples-asp-net-mvc/tree/master/grid-crud

Regards,
Atanas Korchev
the Telerik team