How can I retrieve cosmosDB records by timestamp?

Viewed 37

0

I am not sure if this is an azure cosmosDB table problem I need to configure or simple syntax issue, but I am trying to retrieve all records in cosmosDB created after a timestamp and having a bunch of issues. I'm running a very basic query like this:

select  * from resources where resources.Timestamp >= '2022-09-01T00:00:00.0000000Z'

also tried

select  * from resources where Timestamp >= '2022-09-01T00:00:00.0000000Z'

and retrieving nothing back. When I do a select * on the table I don't see timestamp show up there, just a json mapping of objects in the table but I do see it if I look at it on the portal.

enter image description here

How do I properly do this simple task?

0 Answers
Related