[DocumentDB] Allow Paging (skip/take)
Allowing paging would be huge. Btw, Thank You for rolling out this feature at all! It looks wonderful! Can't wait to try it! However, I won't be able to use it for actual work projects until it supports paging and sorting.
Reopening this user voice item as our support for Skip/Take (Offset/Limit) was only limited to single partition queries.
The newly released .NET SDK v3 now includes support for x-partition queries using Offset/Limit. You can learn more about v3 SDK and try it and provide feedback on our github repo here.
We will also be back-porting this functionality to our .NET v2 SDK. This work will begin shortly and we anticipate it to be released in September.
Once that is released we will mark this feature as complete.
Thank you for your patience and votes.
Jason Kergosien commented
I have to agree with everyone. It's a big deal.
Even if it's not a typical NoSQL feature, it doesn't matter. I'm a convert to NoSQL thanks to Cosmos, but since I'm used to very good functionality with RDBMS, guess what, I expect a lot.
(You can only blame yourself (MS). You spoiled us with great features w/SQL Server :) )
Adoption has got to be a key metric for Cosmos, so this should be important to add.
My 2 cents. Thanks guys!
Update us on this, thank you
Pravin Kadam commented
Any Updates on this?
Hi, still no update to SKIP support ?
Hello, any update on this?
It's been 3.25 years. How long does it take to implement this? We want to switch from RavenDB, but CosmosDB just has too many limitations.
Rob Teixeira commented
Seriously? Still no update to this in over a year? Lack of Skip just torpedoed Cosmos DB for my project. Back to SQL Azure...
Justin Staffer commented
Skip is a big deal for us. LINQ is too slow and we would need to pull a ton of data. Please correct me if I'm wrong.
william lee commented
Will you tell us where you guys are on this? thanks much
Bryce Godfrey commented
Not only skip/take but also the total count in the result set would be beneficial. The example of a list of records where I need to show the total count and let the user page through them.
Now that the Microsoft Build event has ended, can we get an update on this?
Sibin S commented
Its been 3 years :) Common this would be a great addition to it.
Where is this at? What are we supposed to do until this point? Pull the entire data set back and page it in code?
WE NEED THIS NOW! GET IT DONE.
Steve Haran commented
Really need to implement paging - it seems like the most basic of requirements. Please - any updates?
Why is this taking so long? This has been kicking around for ages now.
Question: What is the utility of DocDb if you can't page through results in large datasets?
Any ETA or Update, DoumentDB is a great product. Although without proper paging support (Page forward and Back, get specific page etc) its use in web applications is limited.
So, how far is this?
The link by Henrik Ebbeskog shows how to iterate, but not how to page. (Paging is when the user can go to the previous or next page in a view.)
Furthermore, for a collection to use min/max requires some unique sortable property, which many collections don't have.
(Many have either unique or sortable, but not both.)
Hey folks, this has been in the planned state for almost a year now. Can we please get an update on what that means? Our teams are using DocumentDB in a limited capacity right now and having this feature would be a significant win. I know there are alternatives, but they are messy at best compared to a clean skip implementation. - M@