I was trying to set up a query on baserow with a filter on a link value id. While this works fine with a single value (i.e., Field name X “link row has” and value = row ID), using the same with multiple filters and “or” filter type does not result in the expected output.
In my case, out of the ~10 rows in the table X, two have links to table Y with its row ID 4, and one has a link to table Y with row ID 5. Doing separate queries results in the correct output. Adding two filters with or only returns the latter entry in the filters, ignoring the first filter.
The same occurs when directly comparing values, so there’s something wrong with the “or” filter option it seems, either in n8n, baserow, or the way n8n uses baserow … or am I doing anything wrong?
Even worse, using “and” still results in the same output.
It appears to me as if using multiple filters only works correctly if different columns of a table are used, but not if multiple comparisons are run on the same column … using a second column and comparing values with and or or results in the expected output …
Is this a general limitation in baserow or n8n, or is it a bug in one of the two?