2007-09-05

CAML querying using SPSiteDataQuery and getting distinct values returned

Using SPSiteDataQuery to query lists and sites for specific data is quick and easy. I needed it in a scenario where i needed to query a single list in a site and make sure I don't get any duplicates in the CAML query result.

Combining the following two blog entries from The Kid (who has a lot og great informasjon about SPSiteDataQuery - other stuff), and from Patrick Tisseghem about DataTable and DataView anf how to get distinct values returned.

No comments: