I’m working with a time series object and have been able to insert and query records successfully. However, I’m struggling to filter records based on the timestamp. This is my test query: { "aggregation": [ { "$match": { "metadata.object": "object_1", "timestamp": {"$gte": "2025-01-05T08:40:00.000Z" } } }, { "$project": { "temperature": 1, "humidity": 1, "timestamp": 1 } }, { "$skip": 0 }, { "$limit": 20000 } ] } However, when I run this query, it returns no results. If I remove the timestamp filter from the $match, I do get data back. I also know that the timestamps in my data satisfy the provided condition. How do i do this filtering correcty? Is there something I’m missing?

Hi Sondre! There seems to be a bug on our end with the filtering on timestamp. I’ve reported it to our developer team.

Hi! The issue has been identified and is related to how the timestamp property is parsed. A fix for this issue is scheduled for release 115. Please note that this is subject to change.

Filter time series data object based on timstamp

Ask the community

Olav March 21, 2025, 7:04am 4

Hello! This bug has been fixed in version 115.

Topic		Replies	Views
Equality operator failing on Datetime objects Bug reports app-data	3	100	October 15, 2025
Date today is not working on data source filters Bug reports app-data	1	275	August 17, 2023
Time filter for object class data source Ask the community filtered-selection	3	328	June 9, 2023
Datetime action variable cannot be used for filetering in a read that uses read from other Bug reports	4	96	August 6, 2026
Filtering on recently updated value Bug reports	3	79	March 4, 2025

Filter time series data object based on timstamp

Related topics