Databases
StackOverflow2013
Postsdbo
POSharepoint GetListItems using rowLimit parameter is not limiting the results returned
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSharepoint GetListItems using rowLimit parameter is not limiting the results returned
    text
    copied!<p>In SharePoint I am using the default view of a list. When I use GetListItems method I can pass into it the following:</p> <pre><code>public XmlNode GetListItems ( string listName, string viewName, XmlNode query, XmlNode viewFields, string rowLimit, XmlNode queryOptions, string webID ) </code></pre> <p>I am passing in "" for the viewName and am passing a rowLimit of 1000. By Default view only returns 100 items. 100 Items are still being returned not 1000.</p> <p>Can you use the rowLimit when not specifying a view? Is it possible to bring back 1000 items using the query instead? I do not really want to use a GUID for the viewName as I would have to look it up for each list and perform a big refactor.</p> <p><strong>Update</strong></p> <p>I am now using the guid of the view and my list still returns the incorrect number of items. I know the guid is being used as I sued an incorrect one and it errord out.</p> <p>Any ideas what could be wrong?</p> <p>The code that is being sent to the service is as follows:</p> <pre><code>&lt;GetListItems xmlns='http://schemas.microsoft.com/sharepoint/soap/'&gt; &lt;listName&gt;Media Outlet&lt;/listName&gt; &lt;viewName&gt;{2822F0D9-A905-44B5-8913-34E6497F1AAF}&lt;/viewName&gt; &lt;query&gt;&lt;Query&gt;&lt;Where&gt;&lt;Eq&gt;&lt;FieldRef Name='Outlet_x0020_Type' /&gt;&lt;Value Type='Lookup'&gt;&lt;/Value&gt;&lt;/Eq&gt;&lt;/Where&gt;&lt;OrderBy&gt;&lt;FieldRef Name='Title' /&gt;&lt;/OrderBy&gt;&lt;/Query&gt;&lt;/query&gt; &lt;ViewFields&gt;&lt;/ViewFields&gt; &lt;RowLimit&gt;1000&lt;/RowLimit&gt; &lt;QueryOptions&gt;&lt;/QueryOptions&gt; &lt;webID&gt;&lt;/webID&gt; &lt;/GetListItems&gt; </code></pre> <p><strong>Update</strong> I have tried with a RowLimit as 1 and I still get a lot of the results back???</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload