site.GetSiteData() query on multiple sharepoint lists does not return all list items of one list

Question

We have 18 lists, containing a set of columns on each list, and specific columns for each list. We are using site.GetSiteData(query) for searching in the SiteCollection over all 18 lists for specific criterias. We will aggregate the results and show them on a WebPart.

One list contains 99 items on a subfolder, when i searching for a specific criteria, e.g. status = 'to approve' then one of the newest item was not found, older items are found. The older item contains exact the same data as the newest one.

Perhaps a programming error?! So I removed all items except the newest to the sharepoint recycle bin. A new search found the newest item and it was shown on the WebPart.

Is there a row limit for searching list items. I know only the RowLimit property on the Query object, which sets a limit for the number of items returned in the query per page.

Anybody any ideas ?

Answer 1

There is a limit of 10 list/document libraries for a given SPSiteDataQuery. You will have to divide up your queries and then combine the results. Contrary to popular thought this has not been fixed in the infrastructure update.


http://vspug.com/smc750/2007/07/24/spsitedataquery-limited-to-10-document-libraries-or-lists/

http://support.microsoft.com/kb/946484

---

certdev.com

Answer 2

The limit of 10 lists is not our problem, we have solved this problem so that all fields that will be shown in the GUI must contained in the Query.ViewFields.


As i described in my first post, a one list contains 99 items on a subfolder, when i searching for a specific criteria, e.g. status = 'to approve' then one of the newest item was not found, older items are found. The older item contains exact the same data as the newest one.

Perhaps a programming error?! So I removed all items except the newest to the sharepoint recycle bin. A new search found the newest item and it was shown on the WebPart.


So I think the problem is not the limit of 10 lists!?