Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm attempting to create a DVWP that merges 4 lists that share a content type schema but have distinct permissions. The issue I am having is that if a user does not have permissions to one of the lists the DVWP errors out with Unable to open the specified list.

How would I be able to create such a web part that would allow me to merge these lists showing the user items from only the lists she has access to see?

Edit: To be clear I am not doing a JOIN like you would in SQL. Each item from each list represents a distinct row in the view. The operation I am performing is more like a UNION of tables that share a schema. So if each of the 4 lists had only one item the DVWP would display 4 different rows.

share|improve this question
add comment

2 Answers

up vote 0 down vote accepted

To create a view with data from multiple lists as a "union" it would be more appropiate to use the ContentByQueryWebPart

share|improve this answer
    
Thanks, Per. That seems to have done what we needed! –  Robert Kaucher Nov 6 '12 at 18:17
add comment

Here they discussed the same issue with permission on lists

http://sympmarc.com/2009/07/24/the-right-way-to-join-two-lists-in-a-dvwp/

as well here sample example to join lists.

http://blah.winsmarts.com/2007-10-performing_joins_between_sharepoint_lists.aspx

Hope these helps!

share|improve this answer
    
I had previously Googled and seen what you posted. The problem is no answer is given to the issue and what they are doing in these examples is not what I am doing. I will edit my question to explain better. –  Robert Kaucher Oct 18 '12 at 19:22
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.