How can I retrieve all elements in a List ignoring duplicate entries
So if List A contains:
Employee A
Employee A
Employee B
Employee B
Employee C
Employee D
Employee E
I want to get
Employee A
Employee B
Employee C
Employee D
Employee E
-
1This is a really unclear question, and the answers you are likely to get are going to be all over the map. If you explain your requirement in a little more detail you are likely to get more useful answers. Who knows, maybe you can achieve what you want without using CAML at all!Derek Gusoff– Derek Gusoff2013-09-25 14:32:00 +00:00Commented Sep 25, 2013 at 14:32
-
...and please include the SharePoint version you are using...that matters a lot.Derek Gusoff– Derek Gusoff2013-09-25 14:32:35 +00:00Commented Sep 25, 2013 at 14:32
Add a comment
|
2 Answers
Daniel,
The Distinct operation isn't available in CAML Queries.. However, there are different things you can try.. You can use LINQ to get distinct results:
var distinctItems = (from SPListItem item in items select item["EmployeeName"]).Distinct().ToArray();
Or convert your results to DataView and do something like:
SPList oList = SPContext.Current.Web.Lists["ListName"];
SPQuery query = new SPQuery();
query.Query = "<OrderBy><FieldRef Name='Name' /></OrderBy>";
DataTable dtcamltest = oList.GetItems(query).GetDataTable();
DataView dtview = new DataView(dtcamltest);
DataTable dtdistinct = dtview.ToTable(true, "Name");
answered Sep 24, 2013 at 11:53
Arsalan Adam Khatri
14.6k3 gold badges38 silver badges59 bronze badges
-
@Rinu pls have a look at this answer sharepoint.stackexchange.com/questions/27212/…Arsalan Adam Khatri– Arsalan Adam Khatri2018-03-19 06:14:51 +00:00Commented Mar 19, 2018 at 6:14
CAML query schema for SP2013 doesn't contain distinct still, so I think it is not changed. However you may group results in CAML (using GroupBy element) - it will produce groups for distinct values of the field.
answered Sep 24, 2013 at 12:14
Karthik Jaganathan
7,8784 gold badges36 silver badges51 bronze badges