ansaurus

Question

Retrieving a sharepoint list in Infopath only shows first 100 records

Answer 1

+4 A:

By design, the query will only return the first page of results from the default view for the list. Change the item limit for the default view in SharePoint, and you'll change the returned values for InfoPath.

EDIT (links from my comments, here for greater readability):

Here are sources describing this fix in MSDN forum (scroll to the bottom), a blog comment that describes the SharePoint setting step-by-step, one with a screen cap of the somewhat counter-intuitive interface, and another describing performance implications on the server side.

Hope this helps.

Argalatyr 2009-09-24 02:02:26

The article mentioned has a note as part of the symtoms that the maximum limit for displayed items is 100. Will this affect the the returned rows even if i can the default view? I dont have access to the the view to change that easily.

Nathan Fisher 2009-09-24 02:19:33

Yes, if you increase the item limit of the default view, the query return will increase as well. Am looking for a definitive reference for you...

Argalatyr 2009-09-24 02:23:14

Here's a discussion in the MSDN forum: http://social.msdn.microsoft.com/Forums/en-US/sharepointinfopath/thread/0205e1ba-f205-4c29-9192-a6ba8cdeb12e

Argalatyr 2009-09-24 02:24:51

Here in a blog entry: http://blogs.msdn.com/infopath/archive/2007/01/15/populating-form-data-from-sharepoint-list-views.aspx#8514914

Argalatyr 2009-09-24 02:27:43

A couple more: http://blog-sharepoint.blogspot.com/2009/04/infopath-data-connection-not-returning.html and http://www.getsharepoint.com/blogs/bf/Lists/Posts/Post.aspx?ID=29

Argalatyr 2009-09-24 02:31:47

@Argalatyr - Have not been able to get the permissions changed as yet but I have added a workaround that I found that may be usefull to someone.

Nathan Fisher 2009-09-24 05:02:22

@Argalatyr Thanks for the links. they were very helpfull.

Nathan Fisher 2009-09-24 05:02:57

Answer 2

+1 A:

Just documenting what I have discovered trying to resolve the problem. I have not been able to change the default view as yet as I dont have the permission to. That should change though.

One possible workaround I have found is that you can export the list to Excel which contains all the data that I was looking for. the file that sharepoint produces is an Excel Query file like "export.iqy". You can save and open the file in notepad. which will look something like the following

WEB
1
http://SharepointSite/_vti_bin/owssvr.dll?XMLDATA=1&amp;List={14C4ED2B-3050-4C47-B5F3-6333C3B0FB28}&amp;View={8E6124E0-23F2-4BA2-86E7-96E7F36BAEC8}&amp;RowLimit=0&amp;RootFolder=%2fLists%2fSharepoint%20Sites

Selection={14C4ED2B-3050-4C47-B5F3-6333C3B0FB28}-{8E6124E0-23F2-4BA2-86E7-96E7F36BAEC8}
EditWebPage=
Formatting=None
PreFormattedTextToColumns=True
ConsecutiveDelimitersAsOne=True
SingleBlockTextImport=False
DisableDateRecognition=False
DisableRedirections=False
SharePointApplication=http://SharepointSite/_vti_bin
SharePointListView={8E6124E0-23F2-4BA2-86E7-96E7F36BAEC8}
SharePointListName={14C4ED2B-3050-4C47-B5F3-6333C3B0FB28}
RootFolder=/Lists/My list

You can take the third line which is -

http://SharepointSite/%5Fvti%5Fbin/owssvr.dll?XMLDATA=1&List={14C4ED2B-3050-4C47-B5F3-6333C3B0FB28}&View={8E6124E0-23F2-4BA2-86E7-96E7F36BAEC8}&RowLimit=0&RootFolder=%2fLists%2fSharepoint%20Sites

And use that to retrieve the complete list. I added an new receive data connection, selected an xml document and added the above URL.

It is not formated particullary nice but it will return all the data that I was expecting.

I think that Argalatyr solution is much simpler at this point, but it depends on if i am able to get the default view changed.

Nathan Fisher 2009-09-24 04:18:03

ansaurus

tags:

views:

answers:

Retrieving a sharepoint list in Infopath only shows first 100 records

related questions