Iterate the filters in a RadGridView

[scott]

How can I get the filter expressions - or even the sql generated for the filters - from a RadGridView ?

Thanks

[Vanya Pavlova]

Hi,

You can call ToString() for the grid FilterDescriptors. Generated SQL can be observed server-side from your LINQ provider. 

All the best,
Vanya Pavlova
the Telerik team

[scott]

Hi Vanya.  I'm googling around trying to find out what this means: "Generated SQL can be observed server-side from your LINQ provider." ...  can you give me a hint ?

foreach (ColumnFilterDescriptor fd in fpGrid.FilterDescriptors)
{
    string s = fd.ToString();
    // what comes next ?
}

Many thanks -
Scott

[Milan]

Hello scott,

Could you please give us more details about the end result that you are trying to archive? Why do you need to access your filtering expressions?

Sincerely yours,
Milan
the Telerik team

[scott]

Hi Milan.  Those filters are going to become part of an SQL select statement's where clause downstream.  There is code elsewhere that wants to do:

string sql = "select ... from ... where ... AND " + the stuff from the filters.

Scott

[Vlad]

Hi,

 Usually in Silverlight (for example WCF RIA Services binding) RadGridView filters will generate LINQ expressions and these expressions will be transfered to the server-side using service where the same LINQ expressions will be applied to some LINQ context like LINQ to SQL, Entity Framework, Open Access, etc. and this LINQ context will translate the expressions to SQL.

Best wishes,
Vlad
the Telerik team

[scott]

I can look at the filter expressions themselves and write a parser that emits the stuff in the proper SQL syntax for each filter operator ... yuck ...  Can you think of a way to create a dummy linq to sql context that I can query for the SQL ?

Scott

[Vlad]

Hi,

 You check this blog post - may help you in your case.

Greetings,
Vlad
the Telerik team

[scott]

Hi Vlad.  That blog post was way over my head.  I'd much rather see FilterDescriptor.ToSQL() implemented... Thanks though :)