List filter not working on dates with the "is" selector

Help me!
1

Hi Forest Admin teams,

I have an issue filtering rows by dates with the “is” selector. It seems that your filter applies on miliseconds and not seconds like displayed, causing not matching filter.
So how to filter rows to find a row at a precise date in seconds ?

Thanks for your help

Screenshots bellow:

image
image2000×309 95.7 KB

image
image2000×351 100 KB

image
image2000×1112 148 KB

2

Hi @Aarbel! Welcome back. :wave:

Can you fulfill this part of the template so we can give you the best answer?

  • Project name: …
  • Team name: …
  • Environment name: …
  • Agent (forest package) name & version: …
  • Database type: …

Indeed, your screenshots are relevant. Thanks for sharing them. :pray:
Let me know what agent (forest package) you’re using so we can help you.

kind regards,
Morgan

3

Sorry i missed your feedback, here are the details:

  • Project name: “Clovis V2 (Prod / Staging / Dev)”
  • Team name: no team, just “ADMIN” user
  • Environment name: “Production”
  • Agent (forest package) name & version: “forest-express-sequelize”: “8.5.14”,
  • Database type: PostgreSQL

Thanks a lot for your help !

4

Hello @Aarbel,

You are right, I just reproduced the same behavior, but I think this is the expected behavior. :thinking:

Payload sent to the agent (`forest-express-sequelize` in your case) 
{"field":"createdAt","operator":"equal","value":"2023-09-19T22:00:01.000Z"}

I will share the feedback with our team and come back to you with more information.

In the meantime, you can use the following workaround to fulfill the same behavior.

image
image929×347 19.4 KB

Kind regards,
Morgan