[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SharePoint Lists:  Filtering a list by finding maximum date across rows.

Posted on 2012-09-19
Medium Priority
Last Modified: 2014-03-03
Hi Experts:

I have a list in SharePoint with multiple rows of data like this:

Name    Status      Date

I'd like filter my list so that I see only the _latest_ entry for each Name.

How do i do that?
Question by:epuglise
  • 2

Accepted Solution

morgnl earned 1500 total points
ID: 38416874
If you use SharePoint Designer, you could create a Data View Web Part that sorts the list by the columns Name, Modified and then uses XSLT filtering to hide any row but the first for each name.

Have the DVWP include the Name, Status en Date columns and show all items.

This should perform okay if your list isn't too long (say, a maximum of 1000 items). If your list is longer, you could try any of the following:

1. Create a second list with similar columns and create a workflow or event receiver that runs whenever a new item is added to the first list. Here, you add or update an item in the first list, for each user.

2. Create a custom web part that uses a query to select only the top result for each name.

Author Comment

ID: 38418219
I do not have SharePoint Designer.  I am thinking of connecting the SP list to an Access table and then having a query create a second list, which I'd then link to SP as well.  I would still have to refresh the data manually, but it isn't that dynamic.

In the meantime I will also see if I can get Designer installed.

Author Closing Comment

ID: 39901314
Didn't solve my issue, but might help someone else who has SP Designer.

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pimping Sharepoint 2007 without Server-Side Code Part 1 One of my biggest frustrations with Sharepoint 2007 in the corporate world is that while good-intentioned managers lock down the more interesting capabilities of Sharepoint programming in…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses
Course of the Month19 days, 8 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question