platform icon indicating copy to clipboard operation
platform copied to clipboard

Cockroach adapter uses wrong type for dueDate

Open aonnikov opened this issue 4 months ago • 1 comments

Steps to reproduce:

  1. Add dueDate filter with TODAY value
  2. Change dueDate filter to exact date

When dueDate filter is changed, the app shows error unsupported comparison operator: <string> = ANY <jsonb[]>

This is the dueDate condition in the query (task.data#>>'{dueDate}' = ANY(ARRAY[]::jsonb[])

The root cause of this is the fact, that the adapter does take into account type of the field. Filter provides [undefined, null]as filter value which is converted to ANY(ARRAY[]::jsonb[])

aonnikov avatar Aug 19 '25 10:08 aonnikov

Connected to Huly®: UBERF-13121