[Solved] Cannot Apply Many Filters on Grid

[Enriko]

Hi Telerik,

I need to apply filter rules below, but it seems only apply to the first two column, and ignore all the rest of the columns.

Here JS Code : ( assume grid is $("#grid").data("tgrid") )

function extTelerikGridFilter(grid, value) {
    if (!$.isArray(grid.columns)) throw "Error : First Parameter accept only array.";

    var colLength = grid.columns.length - 1;
    var filterText = "";

    var tempArr = new Array();
    for (var i = 0; i < grid.columns.length; i++) {
        filterText = filterText + "substringof({0},'{1}')".replace("{0}", grid.columns[i].member).replace("{1}", value);
        if (colLength > 0) {
            filterText = filterText + "~or~";
            colLength = colLength - 1;
        }
    }
    console.log(filterText);
    grid.filter(filterText);
}

Result of console.log(filterText) :
substringof(Doc_No,'Opriyandi')~or~substringof(Type,'Opriyandi')~or~substringof(Request_By,'Opriyandi')~or~substringof(Request_Date,'Opriyandi')~or~substringof(Department,'Opriyandi')~or~substringof(Plant,'Opriyandi')~or~substringof(Description,'Opriyandi')~or~substringof(IT_Support,'Opriyandi')~or~substringof(Status,'Opriyandi')

Look before and after applying the filters in attachment.

Is this some kind of bug or perhaps i did something wrong.. Thank You.

*Using Telerik MVC 2011.3.1229
*Please ask me if you need another information regarding my issue. :)

[Enriko]

anybody have solution for this issue ? Appreciate It..

[Vladimir]

Please, see http://stackoverflow.com/a/9437743/303298