For Datetime fields, the lesser than operator is behaving as upper bound exclusive

English Forum Developers & API
1

For Task entity, I am checking for “create_at” and “modified_at” datetime fields, the lesser than operator is behaving as upper bound exclusive.

The observation is when hitting Task search API URL(workspaces/{workspace_gid}/tasks/search) with the following filter-criteria -: created_at.before=2023-07-02T00:00:00.000Z, then the response data does not contain data with created_at=2023-07-02T00:00:00.000Z. Please confirm if this the expected behavior ?

2

Hi @Manoj_Bhosale,

Correct; that’s the behavior I get as well, and what I would expect. In your example, you’re asking for tasks “before” 2023-07-02T00:00:00.000Z, so a task with that created_at time is not before that time so wouldn’t be included.

1 Like