SPServices: How would I add Ascending=False to CAML in GetListItems

Question

How would I use SPServices GetListItems and still be able to add Ascending=False to the CAMLViewFields? I haven't used this for long and I am just wondering if this is possible?

Thanks as always!

Answer 1

You can specify the Ascending=False as an attribute of the FieldRef in the OrderBy element.

 $().SPServices({
    operation: "GetListItems",
    async: false,
    listName: "EmployeeList",
    CAMLViewFields: "<ViewFields></ViewFields>",
    CAMLQuery: "<Query><Where><Eq><FieldRef Name='EmployeeID'/><Value Type='Text'>1</Value></Eq></Where><OrderBy><FieldRef Name='Created' Ascending='False' /></OrderBy></Query>",
    CAMLRowLimit: 1,
    completefunc: function (xData, Status) {

      });
    }
  });
}