Azure table query filter4/7/2024 One side of the expression must be a constant. Note that you can't compare a property to a dynamic value. Use the logical operators defined by the OData Protocol Specification to compare a property to a value.When you're constructing a filter string, keep these rules in mind: Both the PartitionKey and RowKey properties are of type String. Note that the key property names and constant values are case-sensitive. Query Results you can specify these properties as part of the $filter option, as shown in the following section. Query on PartitionKey and RowKeyīecause the PartitionKey and RowKey properties form an entity's primary key, you can use the following special syntax to identify the entity: Don't have any of those? Complete the five-minute quickstart or the developer tutorial to create an account and populate your database. Prerequisitesįor these queries to work, you must have an Azure Cosmos DB account and have entity data in the container. The queries in this article use the following sample People table: Querying Tables and Entities for details on how to query by using the Table API.įor more information on the premium capabilities that Azure Cosmos DB offers, see Azure Cosmos DB Table API and Develop with the Table API in.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |