DevForce Community Forum : Dynamic Group By and Count

Dynamic Group By and Count : That looks like it would do...

Thu, 15 Sep 2011 20:23:42 -700

Author: BringerOD
Subject: 2960
Posted: 15-Sep-2011 at 8:23pm

That looks like it would do it.

I did not think to add a select field of "Count()".

Thanks

Dynamic Group By and Count : Hi Bryan;Is this the type of...

Thu, 15 Sep 2011 20:16:48 -700

Author: DenisK
Subject: 2960
Posted: 15-Sep-2011 at 8:16pm

Hi Bryan;

Is this the type of query that you want to do dynamically?

query.GroupBy(g => g.CategoryID).Select(s => new { Name = s.Key, Total = s.Count() });

if so, this is how you would do it,

var groupBySelector = new AnonymousProjectionSelector().Combine("CategoryID");
var selectSelector = new ProjectionSelector("Key", "Name").Combine("Count()", "Total");

var q0 = query.GroupBy(groupBySelector).Select(selectSelector);

Edited by DenisK - 15-Sep-2011 at 8:26pm

Dynamic Group By and Count : I figured out a way to do it using...

Thu, 15 Sep 2011 15:28:24 -700

Author: BringerOD
Subject: 2960
Posted: 15-Sep-2011 at 3:28pm

I figured out a way to do it using this

http://weblogs.asp.net/scottgu/archive/2008/01/07/dynamic-linq-part-1-using-the-linq-dynamic-query-library.aspx

It’s a way to do linq queries dynamically.

var result = query.GroupBy(“FieldToGroup”,"it").Select("new(Keyas Name, Count() as Total)");

Bryan

Dynamic Group By and Count : Does anyone know how to get a...

Thu, 15 Sep 2011 09:41:52 -700

Author: BringerOD
Subject: 2960
Posted: 15-Sep-2011 at 9:41am

Does anyone know how to get a groupby count from a dynamic query? I can group by a field, I just can't get it's count without pulling all the records down. I just want the group field and how many there are.

This works, but only returns the key.

var selector = new AnonymousProjectionSelector().Combine("Key");

This does not. I was only guessing anyway.

var selector = new AnonymousProjectionSelector().Combine("Key").Combine("Key.Count","Count");

Code

public void ReadDistinctValuesAndCounts(object sender, QueryGroupsEventArgs e)

{

var query = BuildWhereClause(e.CollectionView, e.GroupPath, _baseQuery);

query = BuildSortClause(e.CollectionView, query);

var groupByField = e.ChildGroupPropertyName;

var groupBy = new ProjectionSelector(groupByField);

var selector = new AnonymousProjectionSelector().Combine("Key");

ITypedEntityQuery groupByQuery = query.GroupBy(groupBy).Select(selector);

var result = groupByQuery.Execute();

}