Using Sharepoint 2010 to view items from two different libraries

I am using SharePoint 2010 and  would like to display information from a Site Pages library and a Documents library based upon an identical field name that is contained in both libraries.  My thought was to tie the information together based upon this one field and create a view.  I have tried a Content Query WebPart,  but cannot figure out how to connect information from each library into one view.  

Is this possible to do this? If so, what approach should I start with?  Even though I am a developer to this particular SharePoint site, the farm administrators have disabled the use of SharePoint Designer.   So I cannot use that tool as a resource.

Any help would be appreciated.
DebbieHamataniAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jamie McAllister MVPSharePoint ConsultantCommented:
Not having SharePoint Designer rules out Joined Views, and anything useful with Content By Query WP as you can't edit the XSL either.

I suspect the next most viable option is a script solution using List Joins and Projections. There's a working sample in this thread;

http://stackoverflow.com/questions/25825010/sharepoint-how-to-easily-get-related-child-items-using-jsom
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Rainer JeschorCommented:
Hi,
as Jamie mentioned - without SP Designer the only affordable way would be using either SharePoint JSOM or another client library.
I would suggest to use SPServices (http://spservices.codeplex.com) and for the ease of joining breeze.js (http://www.getbreezenow.com/breezejs)
Just my 2ct
Rainer
0
DebbieHamataniAuthor Commented:
Thanks Jamie and Rainer for the suggestions.  Again having limited administrative access has hampered some of my development options.
Jamie -- if I were to use your solution, how are the functions called.  As with all my css, I have them in a text file and "call" the scripts via a content editor webpart. Would this be the same scenario by placing the code in a text file and "calling" these functions via a content editor webpart?

Rainer -- I have actually looked at using jquery.  Would the library be uploaded to the "site assets" library?  I currently have my css files in that library and reading other articles, this seems the place to place these type of documents.  What I am not sure about is the permissions level the "farm" administrators have dumbed down the site administrators.  Currently I cannot even grant permissions to users.

If there are other areas I could be looking at, please let me know.

Thanks
Debbie
0
Jamie McAllister MVPSharePoint ConsultantCommented:
Hi Debbie,

The scripts should be placed in Site Assets library, and could be surfaced as a reference in CEWP as you suggest.

Scripts will run under the permissions of the user viewing the page, if they have permissions to the source libraries, no issues.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.