Note that no more than 15 discrete comparisons are permitted within a filter string. That the space characters within values do not need to be URL-encoded, as this will be done when the query is The values that may be used in table queries are explained in more detail in the MSDN topic tFilterString("PartitionKey eq 'AccessLogs'") ForĮxample, to query all entities with a PartitionKey value of "AccessLogs" on table query myQuery: The PartitionKey and RowKey property values are String types for comparison purposes. The first operand in a filter comparison must be a property name, and the second operand must evaluate to aĬonstant. Operators defined in TableQuery.Quer圜omparisons and the logical operators defined in TableQuery.Operators. Overloaded generateFilterCondition(,, boolean) methods and combineFilters(,, ) method, using the comparison A filter expression is optional by default a table queryįilter expressions for use with the setFilterString() method can be created using fluent syntax with the Sets the filter expression to use in the table query. If the query will beĮxecuted using an EntityResolver, the caller may specify TableServiceEntity. Require a class type which implements TableEntity and contains a nullary constructor. The TableQuery(Class) constructor and from(Class) static factory methods
The space characters within values do not need to be URL-encoded, as this will be done when the query is executed. The values that may be used in table queries are explained in more detail in the MSDN topic Querying Tables and Entities, but note that Note that the first operand in a filter comparison must be a property name, and the second operand must evaluate to aĬonstant. The comparison operators defined in TableQuery.Quer圜omparisons and the logical operators defined in TableQuery.Operators. The common properties and the property named "Inventor圜ount", and returns them as DynamicTableEntityįilter expressions for use with the where() method or setFilterString() method can be created usingįluent syntax with the overloaded generateFilterCondition(,, boolean) methods and combineFilters(,, ) method, using This example creates a query on the "Products" table for all entities where the PartitionKey value is "ProductsMNO"Īnd the RowKey value is greater than or equal to "Napkin" and requests the first 25 matching entities, selecting only where("(PartitionKey eq 'ProductsMNO') and (RowKey ge 'Napkin')") TableQuery myQuery = om("Products", DynamicTableEntity.class)
TableQuery, so the values saved in the TableQuery will be the last encountered in order ofĪs an example, you could construct a table query using fluent syntax: Note that nothing prevents calling these methods more than once on a Number of entities returned by the query. Select() method to specify the table entity properties to return. Use the where() method to specify a filter expression for the entities returned. TableQuery instance that executes on the named table with entities of the specified TableEntity Use the from(Class) static class factory method to create a Select(), and take() mutator methods each return a reference to the object which can be chained into a To create a table query with fluent syntax, the from() static factory method and the where(), The parameters are encoded and passed to the Methods of CloudTableClient must be called to execute the query. Parameters to use when the query is executed. A TableQuery instance aggregates the query A class which represents a query against a specified table.