DevForce Community Forum : Finding most recent record http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce Classic : Finding most recent record Sun, 12 Apr 2026 23:41:02 -700 Tue, 29 Apr 2008 09:52:54 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=788 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Finding most recent record : Simul-posted with David!David,... http://www.ideablade.com/forum/forum_posts.asp?TID=788&PID=2897#2897 Author: pnschofield
Subject: 788
Posted: 29-Apr-2008 at 9:52am

Simul-posted with David!

David, would the top-1 approach work?
]]> Tue, 29 Apr 2008 09:52:54 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=788&PID=2897#2897 Finding most recent record : Try something like this:RdbQuery... http://www.ideablade.com/forum/forum_posts.asp?TID=788&PID=2895#2895 Author: pnschofield
Subject: 788
Posted: 29-Apr-2008 at 9:51am

Try something like this:

RdbQuery query = new RdbQuery(typeof(Case));
query.AddClause(Case.MemberIdEntityColumn, EntityQueryOp.EQ, mMember.MemberID);
query.AddOrderBy(Case.CaseDate, ListSortDirection.Descending);
query.Top = 1;
Case mostRecentCase = PM.GetEntity<Case>(query);

When you sort the cases for a member by date, descending, the top 1 record will be the most recent.

Paul
]]> Tue, 29 Apr 2008 09:51:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=788&PID=2895#2895 Finding most recent record : Use a PassthroughRdbQuery, http://www.ideablade.com/forum/forum_posts.asp?TID=788&PID=2894#2894 Author: davidklitzke
Subject: 788
Posted: 29-Apr-2008 at 9:46am

Use a PassthroughRdbQuery,]]> Tue, 29 Apr 2008 09:46:45 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=788&PID=2894#2894 Finding most recent record : In SQL, I would use the MAX function... http://www.ideablade.com/forum/forum_posts.asp?TID=788&PID=2882#2882 Author: BillG
Subject: 788
Posted: 27-Apr-2008 at 3:52pm

In SQL, I would use the MAX function to find the most recent case for a member.  Is there an easy way to do it with Entities and OQL or do I have to use a SQL query or stored procedure?
 
BillG
 
]]> Sun, 27 Apr 2008 15:52:09 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=788&PID=2882#2882