CAML - Get Items Under ALL existing Folders

Question

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 View Scope='RecursiveAll' isn't working, any idea why?

<SCRIPT type=text/javascript> get() ;
function get() { var method = "GetListItems";                 
var webURL =  $().SPServices.SPGetCurrentSite() ;                     
var list = "ZooLibrarySlides";                      
var fieldsToRead = "<ViewFields>"+"<FieldRef Name='Name' />" +"</ViewFields>";
var query = "<Query><Where><Neq><FieldRef Name='ContentType' /><Value Type='Text'>Folder</Value></Neq></Where><OrderBy><FieldRef Name='Modified' Ascending='False' /></OrderBy></Query>";

$().SPServices 
({ operation: method, async: false, webURL: webURL, listName: list,
CAMLViewFields: "<ViewFields Properties='True' />",
CAMLRowLimit: 8,
CAMLQueryOptions: "<QueryOptions><ViewAttributes Scope='RecursiveAll' /></QueryOptions>",
CAMLQuery: query, completefunc: function (xData, Status)
{ $(xData.responseXML).SPFilterNode("z:row").each(function() { 

if($(this).attr("ows_DocIcon")== "pptx")
{
var title = $(this).attr("ows_Title");
$("#ISDataTable").append("<tr align='middle'>" +
"<td align='left' class='tooltip'>" +title+ ""</td>" + "</tr>");
}
}); } 
}); }; 
</script>

Answer 1

Add CAMLQueryOption to GetListItems call,

CAMLQueryOptions: "<QueryOptions><ViewAttributes Scope='RecursiveAll'/></QueryOptions>"

Update your CAMLQuey,

CAMLQuery: "<Query> <Where> <Neq><FieldRef Name='ContentType' /><Value Type='Text'>Folder</Value></Neq> </Where> <OrderBy><FieldRef Name='ID' Ascending='False' /></OrderBy></Query>",

Use below logic inside the completefunc for each iteration,

$().SPServices({
        operation: "GetListItems",
        async: false,
        listName: "ZooLibrarySlides",
        CAMLQuery: "<Query> <Where> <Neq><FieldRef Name='ContentType' /><Value Type='Text'>Folder</Value></Neq> </Where> <OrderBy><FieldRef Name='ID' Ascending='False' /></OrderBy></Query>",
        CAMLQueryOptions: "<QueryOptions><ViewAttributes Scope='RecursiveAll'/></QueryOptions>",

        completefunc: function (xData, Status) {        
            $(xData.responseXML).SPFilterNode("z:row").each(function() { 
                if($(this).attr("ows_DocIcon")== "pptx")
                {
                    alert("powerpoint");
                }
            });
        }
      });