{"title":"DB Row Deleter","nodeType":"Sink","id":"*iRBVEGhDlyyAbzwu","factoryName":"org.knime.database.node.io.delete.filter2.DBRowDeleterNodeFactory","factoryId":"org.knime.database.node.io.delete.filter2.DBRowDeleterNodeFactory","path":["DB","Read/Write"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p><a href=\"https://en.wikipedia.org/wiki/Delete_%28SQL%29\" rel=\"ugc nofollow noopener noreferrer\">Deletes</a> rows from a selected database table that match the specified filter criteria.\n <br />\n The filter criteria define an SQL WHERE clause using flat AND/OR logic. If no filter criteria are configured, all rows in the table will be deleted.\n <br />\n The node outputs a one-row status table with the number of deleted rows and any warning, and a pass-through DB Connection port for downstream nodes.</p>\n        ","shortDescription":"Deletes rows from a database table matching configurable filter criteria.","keywords":["database","db","delete","WHERE","filter","rows"],"deprecated":false,"streamable":false,"tags":["DB","Read/Write"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAE0AAABNCAYAAADjCemwAAAACXBIWXMAAD2DAAA9gwGH6AkLAAAFeUlEQVR4nOVc/XUTMQyXef2fbNDbgDIBYQKOCQgTNBuQTkA6QdsJSCfgOgHXCUg2SCYwT0FHTbgPy5Z01/J7z69fV9v5nSzJkmwHAB5+4xEA9vCELTX8XY3fe+/x5/8eIWmxeCASsVVTINI5t/De3wr2NweAecufbpvP6zMbdrIGgAvvPYzRaP6V1BwAYNXByRz//krgxZwDwCUA/HDObZ1zS+fcTKBfLt7RHNba40uQFgIJ/IrS55xbjUTeJY2/0BpAmrQGrwHgC02+VBpjaPwb51xN+kkUWqSFk//mnBNT0ky8AYDvOL6k1GuT1uDTiMQhPpHULyU6O5PoJBJIHPp6q5jHnXMXACCpE1Hqv5KuW3rvq5zOcl0OTkNHeRZp9ivluWwAoBjL5eAA37aaVWPiAxHHhjVpILzkcnDd4fUPwlKncVEznn/HePYxV6eNQVrUXtV7H23pnHMx++cDbvdiDVEfrEk7pOqRTGCQYSEVXLAmDSe+j3hOCgcaU/RFWRqCz9KTH8AduRTiY1pJ2mfJeNcAdiRdWc5rH7QlDXXJW0PCrrz3hSZhoChp+LZXhmSJKvohpIS7+3BPIeExLKQpcvdwuBSWXfs4yUYe/Ib2sHv6XjzMjn22jDMP/p5EEuYEytjNt9AHWfTMaWE5Ttfy3AUpvG2QwuNsbcRAAcQtbfi7kG2hKWx00/MI+n0FGoL39Isp5zXLAcKAwtuQSlwEYUBzKM+0zbMQishukoiLJKxBMUZoKAWcFXDDyUQxCYPjXCyTu7TMyoT/m5EV4xisQeMwoPTb2jHybEHUjCa3pUmsFKwam7ic/jTJQl/ntkVCkkiTJC63Hw2i1oFUtbVk0kQ+sADxEkSVEUSFbSkw5iJFx4lJKnOyaPpLSnGlptjmuaQFUs0lLpswbH9FOcjzvqAfi5N2EeFgmgF3J1SnUSnNq3eHofmm2proflVJ4nrdFXPSJAlTIi7GvzMlrdYgLdC3tTZhfoSyBLWAAAUb5pQMTkF0lMSaNNXgAKUHU4oI7zibfGvSVONxZP1TQu0llXZFw0qf7bX0mX/a4+botH1s6NxS0tSSLSRhFZWLpgJ9vU1smamVpInsBBQk7B8LP+RLWpFWPQP/LHq+FqQNvrmJEda027FI20yEsDrR+V1bkraVzEUKEDbL0H9tQUzxpahCln+K3SURFvSRTZwEaRXF11RP4RFh3BfYqhoSiPvLh+MUwDzQ16o5OGuVM43MsId4JBens+oywbfbYRkXUNVQX1l4bVzu2QpmbnKQsAYJxL1HQXlpGfZowhD4XBD9jSHuuFt4Lhn2GBJYhDWg52NDSr/71lTegkagSFX6jDGGjMOfc12WH7xJHqdm2LsOeYntOAaI00kWd0xkcZLuy8mwl0FfNREpnaiZUb/btipINdKCTHubI5qVYZ9CEzMEGPmkmwrwDf2gA/gmeVLnXMWNvA70h5cW+JZ2dM+SS+KdcwVZnaadR/6rRnKluV7iijbZqr5lFGlB5h3JKZgknUKzRBVvaFjQjTBq/ucZiVxYjgAnP3POUk4B53RDwr3mATbJKMdgUzI8fb4VO+oytTPsB+PxmktNKtLBInhRec8eoIr5iVZRojPrQ7LRpKH7cqJnJfCFIiZZhmKypBFhGkaoMRTX5GizDcWLquVg4jJVXViStpvYMaK71OVvuTy5ZQlLxsUn3xn9Pqt7Odachzkn/vA8VAQOpMNY82iD1fK8GnlpXtMh3mzCwEjS7iRuXUnEAy1FUf9QU9IOVJI5xi1WzdhzjYO9WqQ1F4mMcTvftfbYkstzR8p+M5L+MrtmIoe0XXOr8ohENfgofK1Flzty/Ix9ZQkPwfc1hVn+XAQwhcz7KACAX6PLsRFGwIRRAAAAAElFTkSuQmCC","sinceVersion":"5.12.0","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"DB Connection","description":"A live database connection."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Delete Status","description":"One-row table with optional status and error columns."},{"objectClass":"org.knime.database.port.DBSessionPortObject","color":"cc005b","dataType":"DB Session","optional":false,"name":"DB Connection (Pass-through)","description":"Pass-through of the input DB connection."}],"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":"Database name","description":"The name of the database (or catalogue) to use.","optional":false},{"name":"Schema name","description":"The database schema to read the table from. If not provided, the default schema of the database will be used.","optional":false},{"name":"Table name","description":"Name of the database table to read data from. Must match the table name as it appears in the selected schema.","optional":false},{"name":"Mode","description":"Controls the scope of the delete operation. Switch to &#34;All rows&#34; to truncate the entire table without configuring filter criteria.\n<ul><li><b>Matching rows</b> : Delete only rows that match the configured filter criteria.</li><li><b>All rows</b> : Delete all rows in the table.</li></ul>","optional":false},{"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 to filter on before deleting rows.\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},{"name":"Append status column (to KNIME table)","description":"If selected, it adds an extra column to the output table. The status column is the number of rows affected by the SQL statement. A number greater than or equal to zero indicates that the command was processed successfully and is an update count giving the number of rows in the database that were affected by the command&#39;s execution. A value of -2 indicates that the command was processed successfully but that the number of rows affected is unknown.","optional":false},{"name":"Status column name","description":"Name of the new status column.","optional":false},{"name":"Append error column (to KNIME table)","description":"If selected, it adds an extra column to the output table. The error column shows a warning message, if any.","optional":false},{"name":"Error column name","description":"The name of the error column.","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":[]}