cosmos db sql query with non alphanumeric field name

by

To use a special character, like $, you need to use bracket notation:

SELECT c._id FROM c
order by c._id["$oid"]

You can do this with each property in the hierarchy, so the following also works:

SELECT c._id FROM c
order by c["_id"]["$oid"]

More Related Contents:

  1. Cosmos DB – Deleting a document
  2. How is cosmosDB RU throughput enforced
  3. What is the difference between an Azure Web Site and an Azure Web Role
  4. How can I delete a leased blob in Microsoft Azure storage
  5. AzureStorage Blob Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature
  6. Publish Multiple Projects to Different Locations on Azure Website
  7. Is there a way to persist chat history in MS Bot Framework Web Chat after a page reload/navigation to another page?
  8. Rewriting a URL in an Azure web app
  9. How do I pause an Azure App Service Plan?
  10. How to create a sub container in azure storage location
  11. Logging into Azure Ad with Cypress
  12. Why is “Application permissions” disabled in Azure AD’s “Request API permissions”?
  13. Retrieve the host keys from an azure function app
  14. Is it better to have many small Azure storage blob containers (each with some blobs) or one really large container with tons of blobs?
  15. Differences between Azure Block Blob and Page Blob?
  16. Is it possible to have a link to raw content of file in Azure DevOps
  17. Blue/Green Deployments with Azure ServiceFabric
  18. How to Run Karate API tests on Azure pipelines
  19. headless authentication Azure AD b2c
  20. Azure: Is there any way to deploy different instance sizes for test/production
  21. Using Terraform to import existing resources on Azure
  22. Azure Storage API ContentDisposition
  23. Using ConfigurationBuilder in FunctionsStartup
  24. Azure AD Custom Claims in JWT
  25. Add virtual directory to an existing WebSite
  26. How to check Azure Storage BLOB file uploaded correctly?
  27. Azure Web App Not Using GZip Compression
  28. Azure AD – Why can’t I validate JWT token issued by Azure AD for my Web API? Getting “IDX10516: Signature validation failed” error
  29. Azure Pipeline to trigger Pipeline using YAML
  30. How to get client IP address in Azure Functions C#?

Leave a Comment