SPServices problem fetching maximum data

May 5, 2014 at 9:22 AM
I am facing problem to fetch data. There are 50 rows that need to be fetched, but only 30 has been populated. Please help me.
//The Web Service method we are calling, to read list items we use 'GetListItems'
        var method = "GetListItems";
        
        //The display name of the list we are reading data from
        var list = "Content Metadata Draft";
        //define fields to retrive from list
       
        var fieldsToRead =     "<ViewFields>" 
                                "<FieldRef Name='Metadata_x0020_Name' />" 
                                "<FieldRef Name='Value' />" 
                                 "<FieldRef Name='Editor' />"
                                    "</ViewFields>";
      //CAML query to retrive values from Content Metadata list
                 
        var query = "<Query>" 
                        "<Where>"                        
                             "<Eq>"
                                 "<FieldRef Name='Content_x0020_Name' LookupId='True' />"
                                " <Value Type='Lookup'>"+intContentId+"</Value>"
                                "</Eq> "
                        "</Where>" 
                        "<OrderBy>"  
                            "<FieldRef Name='Metadata_x0020_Name'/>" 
                        "</OrderBy>"                         
                    "</Query>";
        var queryOption= " <QueryOptions><RowLimit>200</RowLimit></QueryOptions>" ;

        //Here is our SPServices Call where we pass in the variables that we have set above
        $().SPServices({
                operation: method,
                async: false,  
                listName: list,
                CAMLViewFields: fieldsToRead,
                  CAMLQuery: query,   
                  CAMLQueryOptions:queryOption,
                    CAMLRowLimit: 200,
                  
                    completefunc: function (xData, Status) {
                    
                        //var   itemCount = parseFloat($(xData.responseXML).find("rs\\:data").attr("ItemCount"));
                        
                        //alert("itemCount "+itemCount );
                        
                     //this code iterates through every row of data returned from the web service call
                        $(xData.responseXML).SPFilterNode("z:row").each(function() { 
                                                 
                            var strMetadataName = ($(this).attr("ows_Metadata_x0020_Name"));  
                                                                        
                            var strMetadataValue = ($(this).attr("ows_Value"));
                            
                            var strEditor = ($(this).attr("ows_Editor")).split(";#")[1];                         
                                                                            
                            
                        });                
                    }
        });
Coordinator
May 5, 2014 at 1:20 PM
Edited May 5, 2014 at 1:20 PM
My guess is that something you're doing in the filtering is simply, well, filtering. Keep in mind that all items you want to retrieve must have all of the columns in the ViewFields.

M.