New answers tagged caml
The trick is to set the CAMLQueryOptions so that you get all the items regardless of what folder they are in. It's sort of like the "folderless" option in a view's settings. CAMLQueryOptions: "<QueryOptions><ViewAttributes Scope='RecursiveAll' /></QueryOptions>"; The GetListItems documentation on MSDN is a little light on these options. ...
Why can't you set the scope to recursive? Because of the amount of items you're retrieving or because it's not supported in CSOM (Not sure about this)? Have you tried filtering by a set amount. For example, retrieving the top 5000, then the next 5000, etc. Quick CAML Designer result: ClientContext clientContext = new ClientContext("your site"); ...
Fired up Wireshark and looked at the XML coming back from SharePoint and saw how to do this. Basically you just set the Field's value to a string with each choice separated by ;# for example if Choices 1 and 3 were selected: <Field Type="Choice" BaseType="Text" Name="Process">;#Choice 1;#Choice 3;#</Field>
http://akanoongo.blogspot.com/2011/02/how-to-resolve-2000-items-resolution-in.html has a PowerShell script which, when ran as farm admin, will increase the External Content Type row filter limt from 2,000 to 20,000. I tried it on our test/dev system, and it works.
Top 50 recent answers are included