Azure Course Labs

Lab Solution

Open Data Explorer and navigate to the FulfilmentLogs entites.

In the Query Builder you can set the properties to filter on:

• remove the default PartitionKey and RowKey fields
• add a new clause where the field Level is equal to Error
• add a new clause where the field Timestamp is greater than or equal to Last Hour

The Explorer knows this is a date/time field and gives you a restricted set of ranges to choose from

Check the Query Text and you’ll see this looks very much like the OData filters we used with Table Storage.

CosmosDB also supports querying over HTTP with OData - but you can’t generate a SAS token to access Cosmos. Instead you need to build an authentication header, which is not straightforward.

This site is open source. Improve this page.