SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

Here they discussed the same issue with permission on lists

as well here sample example to join lists.

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

Your Answer


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.