twenty icon indicating copy to clipboard operation
twenty copied to clipboard

Fix date equals filtering

Open martmull opened this issue 2 years ago • 2 comments

Filtering on dates does not work:

filter: { and: [{createdAt: {eq: '2023-07-14T15:09:17.679Z'}}]} returns 0 values even if such a record exists in the db

martmull avatar Nov 29 '23 10:11 martmull

Input from @magrinj: scalar might not be represented correctly in graphql

charlesBochet avatar Dec 11 '23 14:12 charlesBochet

Filtering seems to be expecting seconds/minutes/hours while most of the time we want to compare YMD.

Screenshot 2024-01-17 at 15 24 59

Probably something to clarify around DATE vs DATETIME field, and make sure that even if DATETIME the filter only compares YmD

FelixMalfait avatar Jan 17 '24 14:01 FelixMalfait

Equal date filtering was removed from DateTime field on the ui, we kept greater than / lesser than only We will introduce a Date field soon (no time), which should support equal filtering

FelixMalfait avatar Apr 05 '24 06:04 FelixMalfait