Joining Multiple Views into one View – Is this Use Case Possible?
This is one of the times where I hope this blog can be a learning tool for myself and for other people. SharePoint is an extremely versatile tool and there is no way that one person can know everything ;^)
I have a custom list created in SharePoint 2010 Foundation that I am using to track “task” type information. I am using a custom list, rather than a task list or calendar list for multiple reasons that I’m not going to get into. This list has the following fields:
- Assigned to
- Date 1
- Date 2
- Date 3
- Date 4
The business requirement is to create a single list that shows “all dates (1, 2, 3, or 4) that are due this week” and several other views based on similar logic. If ANY of the dates (1, 2, 3, or 4) occur in the current week then I want the entire row to show.
Initially, I created a web part page with four views of this list, one for each Date (1, 2, 3, 4) using the following filter for each web part: Show items only when “Date (1, 2, 3, or 4) is greater than or equal to [today] AND Date (1, 2, 3, or 4) is less than or equal to [today]+7”. However, the customer really wants all of this information to be a single list, rather than in four separate web part views.
I have access to SharePoint Designer 2010 but not access to deploy a solution the farm. A sandbox solution might be a possibility if necessary, but I really want to avoid that. We cannot purchase a 3rd party solution.
I am wondering if it possible to accomplish this using client side code and / or a Data View Web Part or Content Query Web Part and XSLT. I am open to any other ideas as well. I also have complete freedom from an information architecture perspective in regard to using site columns and content types. All of the information is located in a single list, in a single site.
Dearest SharePoint Community: Is there some way to fulfill this requirement? Thanks a million for sharing your expertise with us!