# Filter time series data object based on timstamp

**URL:** <https://community.appfarm.io/t/filter-time-series-data-object-based-on-timstamp/1578>\
**Category:** Ask the community\
**Created:** [January 7, 2025, 11:21am UTC](https://community.appfarm.io/t/filter-time-series-data-object-based-on-timstamp/1578 "2025-01-07T11:21:18Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sondre.sagstad](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/sondre.sagstad/32/1642_2.png) [@sondre.sagstad](https://community.appfarm.io/u/sondre.sagstad)\
**Post date:** [January 7, 2025, 11:21am UTC](https://community.appfarm.io/t/filter-time-series-data-object-based-on-timstamp/1578/1 "2025-01-07T11:21:18Z")

</div>

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:

```auto
{
    "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?

---

<div class="post-metadata">

**Author:** ![Shahitha](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/shahitha/32/66_2.png) [@Shahitha](https://community.appfarm.io/u/Shahitha)\
**Post date:** [January 9, 2025, 2:01pm UTC](https://community.appfarm.io/t/filter-time-series-data-object-based-on-timstamp/1578/2 "2025-01-09T14:01:47Z")

</div>

Hi Sondre!

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

---

<div class="post-metadata">

**Author:** ![Lars](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/lars/32/67_2.png) [@Lars](https://community.appfarm.io/u/Lars)\
**Post date:** [February 7, 2025, 7:51am UTC](https://community.appfarm.io/t/filter-time-series-data-object-based-on-timstamp/1578/3 "2025-02-07T07:51:30Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Olav](https://dub1.discourse-cdn.com/flex013/user_avatar/community.appfarm.io/olav/32/63_2.png) [@Olav](https://community.appfarm.io/u/Olav)\
**Post date:** [March 21, 2025, 7:04am UTC](https://community.appfarm.io/t/filter-time-series-data-object-based-on-timstamp/1578/4 "2025-03-21T07:04:57Z")

</div>

Hello! This bug has been fixed in [version 115](https://community.appfarm.io/t/release-notes-115/1742).