Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Recursive and Rowlimit not working #345

Open
badger-mark opened this issue Jun 27, 2024 · 0 comments
Open

Recursive and Rowlimit not working #345

badger-mark opened this issue Jun 27, 2024 · 0 comments
Labels

Comments

@badger-mark
Copy link

I have a Sharepoint 2013 On Prem instance (migrating to SPO shortly). I have a List with over 500k items in it. We have a View inside of this List that usually returns less than 200 records. I cannot query this List directly with a CAML query without hitting the View threshold due to unindexed fields being used in the CAML query.

The View works just fine in the web interface, so I used this package to obtain the View properties and got the ListViewXml property of the View. This is a more verbose CAML query for that particular View. I then passed that CAML query into getItems() and it still hits the view limit threshold. Removing the Scope="Recursive" solves the problem but I need the query to search recursively. I have a row limit of 200 and have paged set to true.

It's almost as if the package isn't recognizing the the row limit and the paged parameters from the query. The examples for how to read large lists simply do not work and seem to be a mashup of different (older versions) of the package. They all return the same threshold limit error.

Does ANYONE have a working example of working with Lists that greatly exceed the 5k view threshold?

@vgrem vgrem added the question label Aug 15, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

2 participants