The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
78 views

Bind GridView using CAML query JOIN

I want to show data from 3 lists in gridview, using CAML query join. I have multiline fields in 2 of these lists. As per my knowledge these multiline fields cant be included in CAML Query JOIN. FYI, ...
0
votes
1answer
73 views

Show attachment in Linked List

I linked two SharePoint lists. They are joined by column ID (like a foreign key). When I click the Display Item of List #2, it also includes the fields of List #1. But I can't figure out how to ...
0
votes
1answer
90 views

Data view web part joined subview fails due to extra characters in ID field

I created a joined subview in a data view web part however it is failing to find any matching items because one of my join columns IdeaID. is bringing in additional characters (see image below). ...
0
votes
1answer
345 views

Join three Lists in CAML

Suppose that we have three tables(Three Lists in SharePoint).The relations between tables are described by the following image. I want to translate the following query to CAML query: select c.* ...
0
votes
1answer
321 views

Add query web part to display form to show related items in another list?

I have a list which contains information that is heavily linked with info in another list. The most similar example that I've seen was where someone had a list of customers and then a total list of ...
0
votes
0answers
107 views

Alternatives to Data View Join?

We would like to show a filtered list of PDF's for managers at an office (location), i.e. List A: Document Library of PDFs with an Office name List B: List of Offices with a "Manager" people column ...
2
votes
1answer
60 views

SP2010 Joined List View Builder: An Impossible Task?

Imagine 2 very large lists: Tickets and Assignments. Assignments is a separate list because the client wants to categorize the assignment type, like BA and PM, plus have fields for estimated/actual ...
0
votes
1answer
215 views

Can you join two lists with a user/person column and display in a DVWP?

I have two lists created in WSS 3.0: 1) User details - A custom list (person, supervisor etc) as I can't gain access to the User Information list and can't get XML Web Services to work. 2) Training ...
0
votes
2answers
2k views

Left Outer Join in SharePoint 2010

I have 2 lists in SharePoint 2010. First List E lists all locations. In the second list H I use first E list as lookup for Location. Every month users inputs information in list H. List E has ...
0
votes
2answers
637 views

CSOM list query with JOIN, return tree structure

I have two lists, Parent and Child. The Child list has a lookup field called "Parent", which "looks into" the Parent list, using ID column. Using CSOM I'm joining the lists with this query ...
1
vote
0answers
126 views

Merge lists and add listname in a new column

As the title says I want to merge some lists with the same columns together and then add a new column with the name of the list this item was extracted from. Is it possible to do this out of the box ...
1
vote
1answer
209 views

SPQuery - join two tables and count each

I have two tables with a 1-M connection and have not been able to correctly convert the following SQL into a caml/spQuery I want every value in table A once no matter what & table B divided into ...
2
votes
4answers
2k views

Joining two lists in a single view or edit form

I'm having trouble creating a joined edit or view form from 2 lists in Sharepoint 2010. Details I have two lists in Sharepoint 2010 that have a 1:1 relationship. When a user creates an entry in the ...
2
votes
0answers
502 views

Reverse lookup with Linq to SharePoint

I have two lists called ‘Events’ (custom list) and ‘Timeslots’ (calendar list), Timeslots has a lookup in to the id column of Events. Each event can have multiple timeslots. I need to show columns ...
1
vote
1answer
2k views

How to join lists in SP 2010 by GUI tools (visual editors)?

Is there any possibility to join Sharepoint 2010 internal data sources (like lists) in "out-of-the-box" Sharepoint 2010 tools or SPD without using programming tools? "Join" and "merge" queries ...
2
votes
3answers
1k views

Export a joined view

I have created a joined view (with a Data View Web Part in SharePoint Designer), how can I export it (ideally to Excel)?
4
votes
1answer
14k views

Combining multiple lists into one

I have two custom lists on the SharePoint website and I would like to create a list which combines/joins the two lists. Is this possible and if so what are the best methods or third party tools for ...
1
vote
1answer
723 views

How can I Filter a Joined DVWP by [Current User] in Multi-User People/Groups field?

I have a joined DVWP. List A includes a "category" lookup field among other columns. List A includes the same "category" lookup field as well as a People/Groups field with multiple selections. I'd ...
5
votes
1answer
202 views

SharePoint Designer Menu for Filtering Joined Views

In SharePoint Designer, is there an easy interface for filtering joined views (either parent or child)? Currently I go to code view to type the filters directly in xslt. There must be an easier way!