When using the DB row filter node and try filtering on a bool column the only options displayed are “IS NULL” and “IS NOT NULL” which seem not to filter based on the boolean value.
DB specs:
DB Type MySQL
DB dialect MySQL
Driver MySQL 8
1 Like
Hello andreottiS,
thanks for reporting this missing feature. We have created a feature request for it and add it to one of the next releases. Until then you can use the DB Query node to write your own SQL query that filters on boolean columns.
Bye
Tobias
2 Likes
This exact problem has made some of my migrations of DB nodes tricky.
Hello everyone,
I’m happy to announce that with KNIME Analytics Platform 4.2 which was released this week the DB Row Filter now also supports boolean columns.
Thanks a lot for all your valuable feedback in the forum.
Bye
Tobias
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.