"SQL" Like Where Clause FROM RadFilter

[Michael]

I remember a few releases ago I was able to get an "SQL" where clause from the filter criteria. Has this functionality been moved? I see the save settings option but I don't think my users will understand base64. I would love to be able to use the filter do generate custom reports.

[Tsvetina]

Hi Michael,

The RadFilter control exposes query providers for a number of different syntaxes, including SQL. You can use the ApplyExpressions server event to get an expression built using the required syntax:

protected void RadFilter1_ApplyExpressions(object sender, RadFilterApplyExpressionsEventArgs e)
{
    RadFilterSqlQueryProvider provider = new RadFilterSqlQueryProvider();
    provider.ProcessGroup(e.ExpressionRoot);
    Response.Write(provider.Result);
}

For more information on building filter expressions you can check out this help article:
http://www.telerik.com/help/aspnet-ajax/filter-building-expressions.html

All the best,
Tsvetina
the Telerik team