How can we improve Azure Cosmos DB?

← Azure Cosmos DB

[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.

3,786 votes

Vote

Sign in

(thinking…)

Sign in with:

Microsoft

Forgot password?

Create a password

Signed in as (Sign out)

You have left! (?) (thinking…)

Fred Steffen shared this idea · Aug 26, 2014 · Flag idea as inappropriate… · Admin →

completed ·

AdminAzure Cosmos DB Team (Product Manager, Microsoft Azure) responded · May 11, 2019

This feature is now complete. For more information on Skip/Take (Limit/Offset), please see the article below.

Thank you for your suggestions and votes.

https://docs.microsoft.com/en-us/azure/cosmos-db/how-to-sql-query#OffsetLimitClause

Show previous admin responses (7)

started ·

AdminAzure Cosmos DB Team (Product Manager, Microsoft Azure) responded · Oct 17, 2018

This feature is currently in active development. We will update this item to complete once it has shipped so those voting/commenting should get notified.

Thank you everyone for your patience.

planned ·

AdminAzure Cosmos DB Team (Product Manager, Microsoft Azure) responded · Mar 5, 2018

We are working on some foundational pieces which will light up skip/take in future.

planned ·

AdminAzure Cosmos DB Team (Product Manager, Microsoft Azure) responded · May 20, 2016

Hi,
Support for SKIP is under review; we will provide an update once we have a confirmed schedule. As previously announced, TOP is supported, and the LINQ provider supports TAKE.

Han Wong
Program Manager
Azure DocumentDB

planned ·

DocumentDB Team responded · Dec 14, 2015

Hi,
We have just released the support for TOP. The LINQ provider will support TAKE.

Han Wong
Program Manager
Azure DocumentDB

planned ·

DocumentDB Team responded · Oct 24, 2014

Hi,
The plan to support paging (skip/take) is in place. I will update the community once the feature is ready to be released.

Han Wong
Program Manager
Azure DocumentDB

planned ·

DocumentDB Team responded · Oct 24, 2014

Hi,
The plan to support paging (skip/take) is in placed. I will update the community once the feature is ready to be released.

Han Wong
Program Manager
Azure DocumentDB

under review ·

DocumentDB Team responded · Sep 16, 2014

Hi, thanks for your feedback. We are currently reviewing this request and will provide an update soon.

Han Wong
Program Manager
Azure DocumentDB

124 comments

Add a comment…

Sign in

(thinking…)

Sign in with:

Microsoft

Forgot password?

Create a password

Signed in as (Sign out)

Submitting...

An error occurred while saving the comment

Anargyros Tomaras commented · June 28, 2019 1:45 PM · Flag as inappropriate

Doesn't work correctly when passing this "SELECT * FROM t OFFSET 0 LIMIT 1" to the Cosmos SDK v2.0. Does this require a specific version of the SDK to work with sqlExpressions (not LINQ) ?

Submitting...
Oleg Gliznutsa commented · May 28, 2019 7:00 AM · Flag as inappropriate

Offset/Limit don't work correctly with EnableCrossPartitionQuery option - e.g. db returns first 15 results when requesting OFFSET 10 LIMIT 5

Submitting...
Shayan Khan commented · May 15, 2019 7:16 AM · Flag as inappropriate

It does not seem to be implemented correctly. I am getting incorrect results when sending a query from my node application

Submitting...
Dipak Yadav commented · May 13, 2019 2:36 AM · Flag as inappropriate

+100

Submitting...
Mani Gandham commented · May 7, 2019 3:42 PM · Flag as inappropriate

Looks like this has been released now for the SQL API: https://docs.microsoft.com/en-us/azure/cosmos-db/sql-api-query-reference

Submitting...
Graeme Christie commented · May 6, 2019 1:32 AM · Flag as inappropriate

+1

Submitting...
Akhil commented · April 29, 2019 3:20 AM · Flag as inappropriate

Any Update on this?

Submitting...
Leng Yang commented · April 24, 2019 12:33 PM · Flag as inappropriate

ETA on this feature? Or MongoDB as alternative

Submitting...
Anonymous commented · April 23, 2019 12:51 AM · Flag as inappropriate

it's just the bad communication around it that bothers me

Submitting...
Zach commented · April 22, 2019 11:20 AM · Flag as inappropriate

Microsoft is notorious for creating half-baked products and customer lock-in. Now, we're stuck waiting for this feature.

Submitting...
sarath commented · April 16, 2019 6:07 AM · Flag as inappropriate

This is worst. No updates for almost one year

Submitting...
Jonathan Chase commented · April 2, 2019 8:50 PM · Flag as inappropriate

Another comment asking for an ETA. I can't stress enough how much this single issue, when combined with the limitation of not being able to use continuation tokens in cross partition queries stops CosmosDB from being a viable option.

Submitting...
Anonymous commented · April 1, 2019 11:42 PM · Flag as inappropriate

This is taking more then a year already, get your **** together, we are paying for this ...

Submitting...
Anonymous commented · April 1, 2019 11:41 PM · Flag as inappropriate

ETA ?????

Submitting...
Rasmus Larsen commented · April 1, 2019 2:37 AM · Flag as inappropriate

ETA?

Submitting...
Patrick Quintal commented · March 27, 2019 7:22 PM · Flag as inappropriate

ETA?

Submitting...
Jon commented · March 13, 2019 9:01 AM · Flag as inappropriate

ETA?

Submitting...
[Deleted User] commented · March 12, 2019 1:12 PM · Flag as inappropriate

dfsdfs

Submitting...
[Deleted User] commented · March 12, 2019 1:11 PM · Flag as inappropriate

test

Submitting...
[Deleted User] commented · March 12, 2019 1:10 PM · Flag as inappropriate

any update?

Submitting...

← Previous 1 2 3 4 5 6 7 Next →

Azure Cosmos DB

Searching…

No results.
Clear search results

Give feedback
- (General Feedback) 3,461 ideas
- Additional Services 296 ideas
- Analytics Platform System 12 ideas
- API Apps 7 ideas
- API Management 424 ideas
- Automation 391 ideas
- Azure Active Directory 3,217 ideas
- Azure Active Directory Application Requests 214 ideas
- Azure Advisor 16 ideas
- Azure Analysis Services 137 ideas
- Azure API for FHIR 2 ideas
- Azure App Configuration 13 ideas
- Azure Backup 398 ideas
- Azure Bastion 9 ideas
- Azure Blockchain Service 2 ideas
- Azure Bot Service 58 ideas
- Azure Cloud Shell 303 ideas
- Azure Confidential Compute 3 ideas
- Azure Container Instances 93 ideas
- Azure Container Registry 56 ideas
- Azure Cosmos DB 217 ideas
- Azure CycleCloud 1 idea
- Azure Data Explorer 49 ideas
- Azure Data Share (Public Preview) 2 ideas
- Azure Database for MariaDB 7 ideas
- Azure Database for MySQL 53 ideas
- Azure Database for PostgreSQL 84 ideas
- Azure Database Migration Service 37 ideas
- Azure Databricks 55 ideas
- Azure DDoS Protection 7 ideas
- Azure Digital Twins 22 ideas
- Azure Event Grid 50 ideas
- Azure Functions 151 ideas
- Azure FXT Edge Filer 0 ideas
- Azure Governance 83 ideas
- Azure Government 77 ideas
- Azure IoT 240 ideas
- Azure IoT Central 78 ideas
- Azure IoT Device Catalog 14 ideas
- Azure IoT Edge 66 ideas
- Azure IoT Solution Accelerators 26 ideas
- Azure Key Vault 107 ideas
- Azure Kinect DK 28 ideas
- Azure Kubernetes Service (AKS) 129 ideas
- Azure Lighthouse 4 ideas
- Azure Management Groups 16 ideas
- Azure Maps 39 ideas
- Azure Marketplace 380 ideas
- Azure Media Services 209 ideas
- Azure Migrate 30 ideas
- Azure mobile app 223 ideas
- Azure Monitor 86 ideas
- Azure Monitor- Alert Management 67 ideas
- Azure Monitor-Application Insights 544 ideas
- Azure Monitor-Log Analytics 875 ideas
- Azure Pack 324 ideas
- Azure portal 1,781 ideas
- Azure Red Hat OpenShift 11 ideas
- Azure Resource Manager 415 ideas
- Azure Search 225 ideas
- Azure Security Center 178 ideas
- Azure Sentinel 19 ideas
- Azure Service Health 16 ideas
- Azure SignalR Service 7 ideas
- Azure Spatial Anchors 16 ideas
- Azure Sphere 48 ideas
- Azure Stack 145 ideas
- Azure TCO Calculator 28 ideas
- Azure Time Series Insights 6 ideas
- Batch 42 ideas
- Batch AI 8 ideas
- Biztalk Services 23 ideas
- Blockchain 40 ideas
- Cache 50 ideas
- CDN 88 ideas
- Change Tracking 7 ideas
- Cloud Services (Web and Worker Role) 283 ideas
- Cost Management 166 ideas
- Customer Insights 13 ideas
- Customer Lockbox for Microsoft Azure 1 idea
- Data Catalog 125 ideas
- Data Factory 682 ideas
- Data Lake 334 ideas
- Data Science VM 19 ideas
- Diagnostics and Monitoring 187 ideas
- Event Hubs 18 ideas
- Global Infrastructure 41 ideas
- HDInsight 123 ideas
- Lab Services 237 ideas
- Logic Apps 1,277 ideas
- Machine Learning 59 ideas
- Mobile Engagement 19 ideas
- Networking 771 ideas
- Notification Hubs 26 ideas
- Scheduler 47 ideas
- Scripting and Command Line Tools 105 ideas
- SDK and Tools 138 ideas
- Security and Compliance 82 ideas
- Service Bus 180 ideas
- Service Fabric 276 ideas
- Signup and Billing 1,380 ideas
- Site Recovery 239 ideas
- SQL Data Sync 68 ideas
- SQL Data Warehouse 244 ideas
- SQL Database 624 ideas
- SQL Managed Instance 87 ideas
- SQL Server 9,547 ideas
- Storage 721 ideas
- StorSimple 45 ideas
- Stream Analytics 224 ideas
- Support Feedback 261 ideas
- System Center Data Protection Manager 109 ideas
- Update Management 102 ideas
- Virtual Machines 1,408 ideas
- Web Apps 361 ideas
Microsoft Azure