Joining Multiple Views into one View – Is this Use Case Possible?

Erica Toelle

Hi! I'm Erica, the Product Evangelist for RecordPoint, focused on Microsoft technologies from Seattle, WA, USA. I enjoy helping organizations with the business and people opportunities and challenges surrounding technology. Please feel free to reach out to me!

You may also like...

10 Responses

  1. StacyDraper says:

    Coras works has a thing that might do this.
    You can use jquery, web services, and HTML.
    A sandbox solution would be a breeze if all these lists are on the same site or even site collection.

    I will confess I haven’t a clue how to do it in spd

  2. I am not sure I totally understand this requirement “However, the customer really wants all of this information to be a single list, rather than in four separate web part views”. Those two conditions don’t seem to be mutually exclusive. Specifically, can you explain what about four separate web parts they didn’t like?

    • Erica Toelle says:

      Hi Doug, They just prefer a single list. It makes it easier to run down all of the upcoming project dates in the weekly status meeting. You are right that they aren’t mutually exclusive: If I can join four views together into a single view for the purposes of the meeting that would be just fine. Thanks for your reply!

      • Ok, I may be stretching my SPD knowledge a bit here, but can’t you create new views (using the All Items as a template) and then modify the view pages in SPD? I think the view pages can be modified to include filter web parts that feed into the dvwp.

    • I was thinking about this some more and I realized that I misunderstood what you were trying to accomplish the first time around. You can accomplish this with a calculated column pretty easily. For example, make the calculated column a boolean and have it return true if all four dates are in the current week. Then have your view show all rows where the calculated column is true.

  3. Erica:

    You can definitely do this in SPD with one DVWP or with SPServices client side. My guess is that there may be another wrinkle or two to your requirements, but I’d go with the DVWP approach based on how you describe it. I don’t think you’d even have to write any XSL, though the filtering will get fairly messy in the dialogs.

    Let me know if you’d like some help.

    M.

  4. graymond says:

    Could you not have a fith Date column which is calculated column. This could look at the other columns and set a value to true or false if Date 1 … Date4 is in the current week, then have a view that displays the data if column5 = true.

  5. Jim Bob Howard says:

    Erica, have you tried setting the filter on you view to show Date 1 >= [Today] And Date 1 = [Today] And Date 2 <= [Today] + 7, etc.?

    If that gives you trouble (try each And set in a different Or order it doesn't work in numerical order), then my next try would be with the DVWP, and modifying the XSL to filter on those criteria. The benefit of that approach is that you'll also be able to mod the display to indicate which date(s) caused it to pass the test.

    Third option would be to load them all, then use jQuery to remove the ones out of range.

    Hope that helps.

    Blessings,
    Jim Bob

  6. Erica Toelle says:

    Thank you everyone – I am almost there! I added the list as a DVWP using SPD and had it filter on the first date. Then I chose “link to another data source”, added the same list and chose to merge the lists. Then I filtered it on the second date, and so on…I am getting a few minor errors but I think it’s because I am tired. I’ll pick it up again tomorrow.

    Special thanks to Steven Wong and Jim Bob, and to everyone else that provided ideas to play around with. When I get this 100% working tomorrow I will write a follow up with the final solution.

    The SharePoint community really is amazing and today I fell in love with xpath expressions 🙂

Leave a Reply to Jim Bob Howard Cancel reply

Your email address will not be published. Required fields are marked *

Skip to toolbar