[Solved] Loop through filtered grid fields

[John]

Hello,

I have a radgrid that is bound to a list of customers - I also have filtering set up on the grid. I have the customer email address as a datakeyname. What I want to do is filter the grid and then generate a list of email addresses from that filtered grid.

But also - I am using paging so I only have 10 results per page. If I filter the grid and I get, for example, 27 results back, I want to retrieve the email addresses of all these 27 records, not just the 10 displaying on the page.

Is this possible?

Thanks.

[John]

Any ideas?

[Vlad]

Hello John,

This should be accomplished at data-source level - the grid does not have any more items or data except the items on the current page.

Best wishes,
Vlad
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center

[John]

ok thanks.

In that case - is it possible to get the current filter method? So, If I just filtered my customers by age lessthan 50, I can then get that filter method (lessthan) and the value (50). Which I can then use to perform an actual sql level query?

[Vlad]

Hi John,

You can get current grid filter string from RadGrid1.MasterTableView.FilterExpression.

Kind regards,
Vlad
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center