DevForce Community Forum : group by and having clauses http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : group by and having clauses Mon, 13 Apr 2026 14:20:40 -700 Sun, 07 Jul 2013 18:28:29 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=4214 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ group by and having clauses : If duesOwed contains items of... http://www.ideablade.com/forum/forum_posts.asp?TID=4214&PID=16551#16551 Author: kimj
Subject: 4214
Posted: 07-Jul-2013 at 6:28pm

If duesOwed contains items of type MemberDuesRecord, then "groups" here will be an IEnumerable<IGrouping<, MemberDuesRecord>>. If you hover over the groups variable, Visual Studio Intellisense will tell you what the type is.

You can do something like this to apply the having and order by clauses:

groups
.Where(g => g.Sum(d => d.DuesAmount) > 0)
.OrderByDescending(g => g.Key)

I'm not quite sure what you want to return, but since an IGrouping is hard to work with it might be easier to project the results into an anonymous type.

This is standard LINQ, so a web search may produce more clever answers.


]]> Sun, 07 Jul 2013 18:28:29 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4214&PID=16551#16551 group by and having clauses : i have an IEnumerable which was... http://www.ideablade.com/forum/forum_posts.asp?TID=4214&PID=16549#16549 Author: BillG
Subject: 4214
Posted: 07-Jul-2013 at 5:54am

i have an IEnumerable which was created by a query of a table. It contains all the dues records for a particular member.
 
duesOwed
 
i need to filter it as follows. I want to group the data by DuesYeaMonth. Thats just a string column in the format 20130701
Year/Month/Day. I only want the rows where the Dues Category code (DuesCatCd) starts with "D" and after they are grouped only those groups where DuesAmount <> 0 and ordered by DuesYearMonth in descending order. So basically i am trying to find the newest dues record still owing and will work my way back to the first.
 
here is what i have so far. I figure it has to be done in two statements.
 
var groups = duesOwed.Where(d => d.DuesCatCd.StartsWith("D")).GroupBy(d => d.DuesYearMonth);
 
now the part i am not sure about
 
var MostRecordDuesRecord = groups.Where(d => d.DuesAmount != 0).OrderByDescending(d => d.DuesYearMonth);
 
What is groups though. Visual Studio doesnt seem to think it is a IEnumerable of DuesOwed records because DuesAmount is in red and it doesnt like the parameter to OrderByAscending.
]]> Sun, 07 Jul 2013 05:54:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=4214&PID=16549#16549