TableStorage
TableStorage copied to clipboard
Filtering by Timestamp isn't working
Describe the Bug
the following query:
await foreach (var item in TablePartition.Create(table, "backed").CreateQuery().Where(x => x.Timestamp > startDate))
{
}
Results in a filter URL that doesn't contain the cast to datetime of the value, and always yields empty results.
Same query using table client does work:
await foreach (var item in tableClient.QueryAsync<TableEntity>(x => x.PartitionKey == "backed" && x.Timestamp > startDate))
{
It seems we could improve things in particular for ITableEntity by simply delegating more to the built-in query mechanism rather than using OData directly in that case.
The underlying issue would still exist for POCO objects with date time properties though 🤔
