Filter Function StartsWith

[JustinWong]

Hi Friends:

In a grid column, I have:  CurrentFilterFunction="StartsWith" and AutoPostBackOnFilter="true" and ShowFilterIcon="false" .  The idea is when user press the enter key, after typing in something in the filter text box, a search using 'StartsWith' will proceed.

This works For as long as there is something typed in the search box.  If the user removes the text and press enters, all the records are returned - which is as expected.

But here's the problem:  Now, the user type in something, say 'Ak' in the search box and press enter, the filter function has changed:  It now defaults to 'Contains' instead of 'StartsWith' 

Is there a way to make sure that with the above scenario, the filter function is ALWAYS 'StartsWith' and nothing else?

Thanks

[Tsvetoslav]

Hi Justin,

The auto-postback filtering of RadGrid is designed to work with the Contains function indeed. However, you can easily circumvent this limitation by attaching an event handler to grid's ItemCommand event, check if a filtering command is coming in, inspect the CommandArgument property of the event args object (e.CommandArgument - it will be of type Pair) and replace its First object with the StartsWith keyword.

protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
    if (e.CommandName == RadGrid.FilterCommandName)
    {
        ((Pair)e.CommandArgument).First = "StartsWith";
    }
}

Hope it helps.

All the best,
Tsvetoslav
the Telerik team