CosmosDB Table API - Order by Datetime

Question

Hi there,

I'm trying to order a query by datetime in one of my tables on CosmosDB Table API but the data returned is not being properly ordered. My project is tied to old libraries if very little room for upgrades.

Environment Information:

• WindowsAzure.Storage 9.3.3.
• .Net Framework 4.6.1

I have tried different approaches like:
datetime'<datetimeUTC>' and simply using TableQuery.GenerateFilterCondition

Is there any option left to try?

Regards.

Nathan Guimaraes.

Answer 1

@Nathan Guimaraes Welcome to Microsoft Q&A forums and thank you for your interest in Azure services.

OrderBy support is made available in newer SDK's Microsoft.Azure.Cosmos.Table and Azure.Data.Tables (beta)
Unfortunately, for the older SDK version that you are using, OrderBy is not supported. You will have to sort the results at client side.

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.