<div>
Group By only works if you also sort. Also you *may* not need the View elements.
</div>


Group By only works if you also sort. Also you *may* not need the View elements.

<div>
<div class="content wysiwyg-content">
I have a SP list that I am trying to retrieve in my silvelight project.<br />
Please note that I am using the Microsoft.Sharepoint.Clien<wbr />t.Silverli<wbr />ght dll<br />
<br />
I have a SP List called Region, which has a few columns. I am trying to get a distinct set of data from the list<br />
<br />
Here is my code<br />
<br />
<br />
ListItemCollection allRegions;<br />
SP.List oList = oWebsite.Lists.GetByTitle(<wbr />&quot;Region&quot;);<wbr /> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CamlQuery camlQuery = new CamlQuery();<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; camlQuery.ViewXml = &quot;&lt;View&gt;&lt;GroupBy&gt;&lt;FieldRef Name='Location_x0020__x002<wbr />0_'/&gt;&lt;/Gro<wbr />upBy&gt;&lt;/Vie<wbr />w&gt;&quot;;<br />
<br />
clientContext.Load(allRegi<wbr />ons, <br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; items =&gt; items.Include(<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;item =&gt; item[&quot;Location_x0020__x002<wbr />0_&quot;] )<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; );
</div>
</div>


I have a SP list that I am trying to retrieve in my silvelight project.
Please note that I am using the Microsoft.Sharepoint.Client.Silverlight dll

I have a SP List called Region, which has a few columns. I am trying to get a distinct set of data from the list

Here is my code


ListItemCollection allRegions;
SP.List oList = oWebsite.Lists.GetByTitle("Region");              
                
                CamlQuery camlQuery = new CamlQuery();
                              camlQuery.ViewXml = "<View><GroupBy><FieldRef Name='Location_x0020__x0020_'/></GroupBy></View>";

clientContext.Load(allRegions, 
                    items => items.Include(
                         item => item["Location_x0020__x0020_"] )
                         )
                                         
                      );

CAML query to groupby does not work to get sharepoint list

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.

Microsoft SharePoint

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).