This question is locked. New answers and comments are not allowed.
Hello,
I have a sum aggregation I need to compute for my grid, but this aggregation is on a calculated property ("value * count" style), which means I cannot use the grid aggregates system along with Entity Framework (which cannot translate calculated properties to SQL). Instead, I need to build a query with the calculated property expanded.
But I need to make this computation by taking account of the different filtering and potentially grouping that are applied to the grid.
I understood the GridModel is taking my IQueryable and apply automatically the filtering/sorting/grouping selected by the user. What I need is to retrieve this IQueryable AFTER it's filtered, so I can use it to make my own aggregate computation on the same set of data, without having to use Dynamic Linq to create the exact same IQueryable by myself. Is it possible? Or is there somewhere a method I can pass both my IQueryable and GridCommand to get it filtered (but not executed)?
Thanks for your help.
I have a sum aggregation I need to compute for my grid, but this aggregation is on a calculated property ("value * count" style), which means I cannot use the grid aggregates system along with Entity Framework (which cannot translate calculated properties to SQL). Instead, I need to build a query with the calculated property expanded.
But I need to make this computation by taking account of the different filtering and potentially grouping that are applied to the grid.
I understood the GridModel is taking my IQueryable and apply automatically the filtering/sorting/grouping selected by the user. What I need is to retrieve this IQueryable AFTER it's filtered, so I can use it to make my own aggregate computation on the same set of data, without having to use Dynamic Linq to create the exact same IQueryable by myself. Is it possible? Or is there somewhere a method I can pass both my IQueryable and GridCommand to get it filtered (but not executed)?
Thanks for your help.