{"title":"DB Row Filter","nodeType":"Manipulator","id":"*kCnGJ8ULaPafiaK5","factoryName":"org.knime.database.node.manipulation.filter.row2.DBFilterRow2NodeFactory","factoryId":"org.knime.database.node.manipulation.filter.row2.DBFilterRow2NodeFactory","path":["DB","Query"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node allows rows to be filtered from the input DB Data table so that the resulting DB Data table will only contain the rows that match the specified filter criteria.\n <br />\n Within the dialog, an SQL WHERE clause is interactively created by adding and connecting filter criteria.</p>\n        ","shortDescription":"The DB Row Filter allows rows to be excluded from the input DB Data table.","keywords":["database","db","WHERE"],"deprecated":false,"streamable":false,"tags":["DB","Query"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6NUE3RDA5QTc4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6NUE3RDA5QTY4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo3ODRGNThCQjgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo3ODRGNThCQzgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/PpWKOHAAAACtSURBVHjaYmZgYLgNxI5ALALE94H4GwOJ4D8SBmlOwKMOGxvFABD+gkfuPzEG1JPqgt9AfA6I+4BYl4EMwESGnv+4JFSBuJWEgAeDdCCeCsTX0CVwBCIM/4CpRZd4S4kBe4BYi1QvNANxOBDLEtDESEwggoAeqVEiAMR2QNwIxOfxmI41ITFi0fAPiJnxOBWmhxFbSH8H4kJSXXATiK8A8XEgXgbEz0jxP0CAAQAAFVaJJa/S8gAAAABJRU5ErkJggg==","sinceVersion":"5.12.0","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data","description":"DB Data to apply filtering."}],"outPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"Filtered DB Data","description":"DB Data with matching rows."}],"dynInPorts":[],"dynOutPorts":[],"additionalSiteInformation":{"url":"https://update.knime.com/analytics-platform/5.12","trusted":true,"enabledByDefault":true,"name":"KNIME Analytics Platform 5.12 Update Site","version":"5.12.0"},"dialog":[{"sectionName":"Options","fields":[{"name":"Match row if matched by","description":"Match the row if all or any criteria match:\n<ul><li><b>All criteria</b> : a row is matched if <i>all</i> of the criteria match (intersection of matches)</li><li><b>Any criterion</b> : a row is matched if <i>at least one</i> of the criteria matches (union of matches)</li></ul>","optional":false},{"name":"Filter criteria","description":"The list of criteria that should be filtered on.\n<ul><li><b>Filter column</b> : The column on which to apply the filter.</li><li><b>Operator</b> : Select the filter operator to apply.</li><li><b>Filter value</b> : The value to compare the column against. The type of input depends on the selected column&#39;s data type.</li></ul>","optional":false}]}],"links":[],"kudos":[],"kudosCount":0,"bundleInformation":{"bundleVersion":"5.12.0.v202606171318","bundleName":"KNIME database nodes","bundleSymbolicName":"org.knime.database.nodes","bundleVendor":"KNIME AG, Zurich, Switzerland","featureSymbolicName":"org.knime.features.database","featureName":"KNIME Database","featureVersion":"5.12.0.v202606171318","featureVendor":"KNIME AG, Zurich, Switzerland","extensionId":"*0mIkLShcIfCXS7Y-"},"frequentSuccessors":[]}