How to do a Full Text Search filter

2 posts, 0 answers
  1. Meerkat
    Meerkat avatar
    64 posts
    Member since:
    Feb 2007

    Posted 10 Apr 2013 Link to this post

    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.
  2. Atanas Korchev
    Admin
    Atanas Korchev avatar
    8462 posts

    Posted 11 Apr 2013 Link to this post

    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
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
Back to Top