I have about 10 Document folders in my list ‘ZooLibrary’ and
I would like Query to display all the PowerPoint files title from the folders in the list, sorted by ID.
Currently, my code isn’t working, any idea why?
<SCRIPT type=text/javascript> get() ; function get() { var method = "GetListItems"; var webURL = $ ().SPServices.SPGetCurrentSite() ; var list = "ZooLibrary"; var fieldsToRead = "<ViewFields>"+"<FieldRef Name='Name' />" +"</ViewFields>"; var query = "<ViewScope='Recursive' /><Query><OrderBy><FieldRef Name='ID' Ascending='False' /></OrderBy></Query></View>"; $ ().SPServices ({ operation: method, async: false, webURL: webURL, listName: list, CAMLViewFields: "<ViewFields Properties='True' />", CAMLRowLimit: 8, CAMLQuery: query, completefunc: function (xData, Status) { $ (xData.responseXML).SPFilterNode("z:row").each(function() { var title = $ (this).attr("ows_Title"); $ ("#ISDataTable").append("<tr align='middle'>" + "<td align='left'>" +title+ "</td>" + "</tr>"); }); } }); }; </script>