DB Row Filter with boolean not working ?

KNIME Analytics Platform
1

Hello,
i have a problem with the DB row filter (column of type Boolean). I can set the following condition for the column: IS NULL or IS NOT NULL.
If IS NULL, the result is an empty table.
If IS NOT NULL, the table corresponds to the input table.
There is no filtering for the values ​​TRUE (1) or FALSE (0) in the table. What am I doing wrong?
KNIME Version: 4.1.3
DB PostgresQL
Thanks for help…

2

Hello Tim8200,
support for Boolean columns was added in version 4.2. If you can not update you can use the DB Query node to write your own query.
Bye
Tobias

1 Like
3

hello @tobias.koetter ,
thanks… I’ve now used the query node

1 Like
4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.