kamagra how much to take

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:

  1. <View>
  2. <ViewFields>
  3. <FieldRef Name="ID_X" />
  4. <FieldRef Name="ID"/>
  5. <FieldRef Name="Title"/>
  6. </ViewFields>
  7. <Joins>
  8. <Join Type="LEFT" ListAlias="Test">
  9. <Eq>
  10. <FieldRef Name="ID_List_X" RefType="ID" />
  11. <FieldRef List="X" Name="ID" />
  12. </Eq>
  13. </Join>
  14. </Joins>
  15. <ProjectedFields>
  16. <Field Name="ID_X" Type="Lookup" List="X" ShowField="ID" />
  17. </ProjectedFields>
  18. </View>

Pretty easy!

Share

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>