SPQuery Based Joins In SharePoint 2010

Company | Articles & Research | Services | Software |

Our Company

All SharePoint Articles

Security

Development

Accounting / Dynamics

AIS / Dynamics GP

Other

Consulting Services

Freeware / Experiments

Applications	WebParts	Security Components
SharePoint Field Diff And Copy Utility * Written In January, 2012 SharePoint Security Scanner * Written In January, 2012 SharePoint Kerberos Buddy * Written In Feburary, 2011 BioPoint: SharePoint Biometric Authentication * Written In September, 2007 SharePoint List Security Migrator * Written In August, 2007 SharePoint Anti-Keylogger™ * Written In April, 2006 S.M.A.R.T SharePoint™ * Written In May, 2006 SharePoint Sentinel™ * Written In June, 2006 SharePoint Scrubber™ * Written In July, 2006 SharePoint Safeguard™ * Written In August, 2006	SecureSilverlight For SharePoint * Written In January, 2010 Simple Rollup WebPart For SharePoint * Written In Novemember, 2009 SimpleChart For SharePoint * Written In December, 2009 SimpleSecurity For SharePoint * Written In June, 2009 CrytoCollaboration (Encryption) * Written In June, 2007 Sample AJAX Rotator WebPart * Written In July, 2007 Sample SharePoint Redirector WebPart * Written In August, 2006 WFE Server Name WebPart * Written In January, 2006	PDF IRM Protector * Written In December, 2010 ADAM Role Provider * Written In February, 2007 Universal Provider Framework * Written In April, 2007

Contact

SPQuery Based Joins In SharePoint 2010

While working with a client today on some SharePoint 2010 code, the requirement can up to do some query based joins. I hadn't done this before in SP 2010, but it's pretty sweet. The only way I have gotten around it in previous versions was converting the list data into data tables and then working with it in that format. Natively working with it is a whole lot less code, whole lot less complicated too. Even for permanent join type stuff, you can use projected fields which is really nice.

So, what's it look like? Consider the following snippet:

PLAIN TEXT

XML:

<View>
<ViewFields>
<FieldRef Name="ID_X" />
<FieldRef Name="ID"/>
<FieldRef Name="Title"/>
</ViewFields>
<Joins>
<Join Type="LEFT" ListAlias="Test">
<Eq>
<FieldRef Name="ID_List_X" RefType="ID" />
<FieldRef List="X" Name="ID" />
</Eq>
</Join>
</Joins>
<ProjectedFields>
<Field Name="ID_X" Type="Lookup" List="X" ShowField="ID" />
</ProjectedFields>
</View>

Pretty easy!

Article Or Research Filed Under SharePoint Development.

2 Comments »

[...] SPQuery Based Joins In SharePoint 2010 [...]

Pingback by SharePoint 2010: Recopilatorio de enlaces interesantes (VII! - Blog del CIIN) — May 1, 2010 @ 12:10 pm
you can usa LINQ to do joins, it’s easier IMHO, CAML can be used as a filter

Comment by decatec — June 5, 2010 @ 2:38 pm

RSS feed for comments on this post. TrackBack URL

Articles & Research

Latests SharePoint Development Posts

Latests SharePoint Security Posts

SPQuery Based Joins In SharePoint 2010

2 Comments »

Leave a comment