Filtering when using a ViewModel

[Keith]

Hi all,

I use a ViewModel when binding to a grid.
However when using the filtering function I get the following:

Invalid property or field - 'UserName' for type: ErrorLog

Username is only a property in the ErrorLogViewModel

The code to fill my view model is:
public ActionResult ListErrors([DataSourceRequest]DataSourceRequest request)
        {
            IQueryable<ErrorLog> errorLogs = (IQueryable<ErrorLog>)db.ErrorLogs.Include(e => e.User).OrderByDescending(e => e.ErrorLogId);
            DataSourceResult result = errorLogs.ToDataSourceResult(request, errorLog => new ErrorLogViewModel
                {
                    ErrorLogId = errorLog.ErrorLogId,
                    Message = errorLog.AdditionalMessage,
                    Timestamp = errorLog.Timestamp,
                    UserName = errorLog.User.UserName
                });
            return Json(result);
        }

Thanks,
Keith. 

[Keith]

For anybody wondering, this sorted it:

IQueryable<ErrorLog> errorLogs = (IQueryable<ErrorLog>)db.ErrorLogs.Include(e => e.User).OrderByDescending(e => e.ErrorLogId);
            DataSourceResult result = errorLogs.Select(errorLog => new ErrorLogViewModel
                {
                    ErrorLogId = errorLog.ErrorLogId,
                    Message = errorLog.AdditionalMessage,
                    Timestamp = errorLog.Timestamp,
                    UserName = errorLog.User.UserName
                }).ToDataSourceResult(request);
            return Json(result);

[K'Library]

Hi Keith,

I read

 http://www.telerik.com/forums/custom-predicate-building-when-filtering 

and write a small project to finish filtering when using a view model:

https://github.com/keith-leung/telerik-aspnet-mvc-grid-diffviewmodel

I hope it helps you and the others.

 

[K'Library]

Another filtering sample thread:

http://www.telerik.com/forums/todatasourceresult

[Maria Ilieva]

Hello Keith,

Thank you for the provided information and for the solutions in this scenario. I'm sure this information will help other users to implement this functionality.

Regards,
Maria Ilieva
Telerik by Progress