Ordering results in any other way is not currently supported. Query results are sorted by PartitionKey, then by RowKey. To return all entities in a table, specify the table name on the URI, without the Tables resource: () To return a single named table, specify that table as follows: ('MyTable') The basic URI for addressing the Tables resource is as follows: To return all of the tables in a given storage account, perform a GET operation on the Tables resource, as described in the Query Tables operation. The following sections describe query options and demonstrate some common scenarios. You can copy the code or use my NuGet library.Querying tables and entities in the Table service requires careful construction of the request URI. These two helper methods show how to do this and how to convert the ticks string back to DateTimeOffset. Before using it as a PrimaryKey or RowKey we do need to convert this to a string while making sure all future values have the same length with leading zeroes when necessary. One way to ensure this is by converting the current DateTime to a ever-decreasing number of ticks by subtracting it from the DateTime.Max value. By making sure this combination comes first in alphabetical order for every new entry makes it easy to just ask for the very first row. However, we can use the fact that all rows in the Azure Table Storage are sorted by PartitionKey + RowKey to our advantage. This could be narrowed down by for example knowing on which day a record was added and filtering accordingly, but we’d probably still get multiple rows to check manually for the newest one. While there’s of course the Timestamp column that could be used to indetify the desired row, we would need to query the whole table to find the youngest date. Recently I had the requirement of retreiving the newest entry in an Azure Table Storage table.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |