Issues with filters for Baserow integration

[choxnox]

Bug Description

There are currently 2 issues when querying Baserow service:

1. The Is False filter seem to be missing (the Is True is there)
2. The Is True filter is actually behaving the opposite of what it seem to be

For issue 2, when I add Is True filter then I'm getting results only where the selected field is actually false which is the opposite of the expected behavior.

To Reproduce

For issue 1:

1. Add Baserow integration to the workflow
2. Click Add option
3. Click Filters
4. Click Add filter
5. Under the Filter field notice the absence of the Is False option

For issue 2:

1. Add Baserow integration to the workflow
2. Set it up so that it fetches multiple rows (make sure at least one field in the table is Boolean)
3. Set the filter on the field to Is True
4. Notice that is only returns rows where the field is false

Expected behavior

Issue 1 - The Is False option should be in the list of conditions

Issue 2 - The Is True option should return rows where the value is true

Operating System

MacOS 14.7.1

n8n Version

1.76.0

Node.js Version

20.18.0

Database

SQLite (default)

Execution mode

main (default)

[Joffcom]

Hey @choxnox,

We have created an internal ticket to look into this which we will be tracking as "N8N-8212"