How can I achieve multiple column filtering and sorting using mvc grid custom server binding

[Raju]

Hi,

      I am trying to implement multiple column filtering using mvc grid custom server binding. While implementing that I was able filter a single column but when I try to do filter with more than one column I am getting the below server error.

Unable to cast object of type 'Telerik.Web.Mvc.CompositeFilterDescriptor' to type 'Telerik.Web.Mvc.FilterDescriptor'.

    When I filter it by on one column it is working fine with FilterDescriptor but with more than one column it is expecting CompositeFilterDescriptor.

   If anyone knows the solution please help me.

Regards,
Raju

[Carling]

I'm having the same issue.  Works with a single filter, but not multiple.  Anyone?

here is my code:

public ActionResult _SelectAccountsBinding(GridCommand command, int serviceAgreementId)

{

  var listRequest = new ContractService.ListRequest();

  var filters = new List<ContractService.SearchFilter>();

  var sorters = new List<ContractService.Sorter>();

 

  foreach (var filter in command.FilterDescriptors)

  {

      var searchFilter = new ContractService.SearchFilter();

      var commandFilter = (FilterDescriptor)filter; // <-- won't cast


      searchFilter.Member = commandFilter.Member;

      searchFilter.SearchTerm = commandFilter.ConvertedValue.ToString();

      filters.Add(searchFilter);

  }

...

[Carling]

I found help here! http://www.telerik.com/community/forums/aspnet-mvc/grid/example-of-custom-filtering.aspx