[Solved] OR Filter

[ashish]

Dear TeamMember,

We are working on ASP.Net MVC application using Telerik grid.
By default AND filter is available for filtering.
Is there any workaround to Modify it so that User can Select AND/OR condition for filtering a particular column.
i.e. A column named as Color can be filtered like :
"red"
OR
"green"

Thanks,
Ashish

[Rick]

I also would like to see this functionality.

As a workaround I can do the OR filter server-side before passing my IEnumerable<T> to the grid model, but this isn't very flexible.

[Ammar]

How did you achieve "OR" filtering with Telerik MVC Grid. A code snippet will be highly appreciated. Appreciate a quick reply.

Thanks,
Ammar

[Raymond]

Anyone have a resolution on this? I'd like to see the functionality too.

[Alex]

I'm interested in this too.  How do we create an OR filter option?

[Stef Heyenrath]

I've the same question, see this page.

Currently I'm trying to build an AND/OR filter, it almost works, the missing functionality is that the AND or OR selection is not remembered after the grid is refreshed.

I keep you informed about the progress.

[update @ 3 December 2012]
Add this helper jquery function which replaces 'And' with a dropdownlist:

$(".GridFilter_Replace_And_By_AndOr .t-filter").click(function () {
    setTimeout(function () {
        var div = $('.t-filter-options, .t-group, .t-popup');
        var divHelpText = div.find(".t-filter-help-text:contains('And')");

        // Remove text
        divHelpText.text('');

        // Create select element and append this to divHelpText
        var s = $('<select />').attr("class", "andor_ddl");
        $('<option />', { value: '', text: 'And'}).appendTo(s);
        $('<option />', { value: 'or', text: 'Or' }).appendTo(s);
        divHelpText.append(s);
    });
});

And use this javascript client function in the 'OnDataBinding' in the grid:

function MyGrid_OnDataBinding(e) {
    var grid = $(this).data('tGrid');
    var filterBy = grid.filterBy;

    // Replace invalid OR filter (if present)
    // Example : ORUCode~startswith~'1'~or~ORUCode~startswith~'2'
    if (e != null && e.filteredColumns != null && e.filteredColumns.length > 0) {
        e.filteredColumns.forEach(function(filteredColumn) {
            filterBy = filterBy.replace("~and~" + filteredColumn.member + "~~'or'~and~", "~or~");
        });

        grid.filterBy = filterBy;
    }
}

And make sure that the function defined in the first step is executed for a specified column, like this:

columns.Bound(p => p.ORUCode).HeaderHtmlAttributes(new { @class = "GridFilter_Replace_And_By_AndOr" });

There is still the problem that the selected value "And" or "Or" in the dropdownlist is not remembered. I'm still working on that...