Get the items in descending order using caml query

Question

i am trying to get the comments from Comment List in a 'Descending' order , the query that i am using is :

"<Where>" +
  "<Eq>" +
    "<FieldRef Name='TopicID' /><Value Type='Text'>" + ProjectID + "</Value>" +
  "</Eq>" +
  " <OrderBy>"+
    "<FieldRef Name='Created' Ascending='False' />"+
  " </OrderBy>"+  
"</Where>";

but this query gives me the result in 'Ascending' order even if i set it to false. what is wrong here?

Answer 1

OrderBy should be outside of the Where clause. Try modifying your query to this:

"<Where>" +
 "<Eq>" +
    "<FieldRef Name='TopicID' /><Value Type='Text'>" + ProjectID + "</Value>" +
   "</Eq>" +
"</Where>" +
      " <OrderBy>"+
   "<FieldRef Name='Created' Ascending='False' />"+
       "</OrderBy>" ;