Sorting SPListItemCollection using CAML Query?

Question

Hi,

I have a SPListItemCollection from all the list items from a list I retrieve programmatically, is there a way that I can
sort by the Title alphabetically?  or sort by date descending?

Is there a way to do this?  Can CAML Query do this?  Thanks.

Answer 1

CAML can do this using the OrderBy element, for example:

<Query>
   <OrderBy>     
      <FieldRef Name='Title' />
   </OrderBy>
</Query>

Here's some code to show how it can be used:

SPList list= web.Lists["MyList"];    
                          
SPQuery q=new SPQuery();

q.Query="<OrderBy><FieldRef Name='Title' /></OrderBy>";

SPListItemCollection items = list.GetItems(q);

---

Ch. - My Blog

Answer 2

Refer to this link for using SPQuery to sort http://blog.qumsieh.ca/2008/11/06/how-to-write-an-spquery-to-sort-your-list/

---

---
Rajesh | My Blog
MCTS - WSS AD, WSS Config, MOSS Config.

Answer 3

Hi,

Thanks for the replies, I have a complex query, was wondering if it is possible.

I have a list with a field named Managers and a date column.  I want to first sort by Managers then by oldest date.

IE:
AManager:
//all the items related to AManager but sorted by descending date
...
..
.
BManager
//all the items related to BManager but sorted by descending date
...
..
.

Answer 4

You can add multiple fieldrefs with the orderby. Although your best bet for creating CAML queries is U2U's CAML query builder (http://www.u2u.be/Res/Tools/CamlQueryBuilder.aspx)

It'll give you a nice GUI that you can mess aroudn with to get the results that you need. YOu can then cut and paste the CAML into your app.

---

Ch. - My Blog

Answer 5

Hi,
You can try the following code,

<OrderBy>
  <FieldRef Name="AManager"/>
  <FieldRef Name="AMOldestDate" Ascending="FALSE"/>
  <FieldRef Name="BManager"/>
  <FieldRef Name="BMOldestDate" Ascending="FALSE"/>
</OrderBy>

---

Shantha Kumar T - MCTS

(B) http://ktskumar.com/blog

(T) http://twitter.com/ktskumar
IOTAP

Answer 6

Thanks for replies!