{"title":"DB Parameterized Query Reader","nodeType":"Source","id":"*XGaHanhyHTSgL1A1","factoryName":"org.knime.database.node.io.parameterizedquery.ParameterizedDBSQLQueryNodeFactory","factoryId":"org.knime.database.node.io.parameterizedquery.ParameterizedDBSQLQueryNodeFactory","path":["DB","Read/Write"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node runs SQL queries in the connected database restricted by the possible values given by the KNIME input table. It restricts each SQL query so that only rows that match the possible values from the input table are retrieved.</p>\n        ","shortDescription":"This node runs SQL queries in the connected database restricted by the possible values given by the input \n        KNIME data table.","keywords":["database","db","sql"],"deprecated":false,"streamable":true,"tags":["DB","Read/Write","Streamable"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6Njg1OUE1QjQ4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6Njg1OUE1QjM4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo5M0Y0RDE3NDgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo5M0Y0RDE3NTgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pg+5GtAAAADzSURBVHjaYmJgYLgNxOuAOBuIRRgwAScQdwLxXyD+D8RLgVgIWcF/JPwNiBPQDCiAyr0B4ltQ9nRcBoDwFzQDQGLbgdgJiA2B+CsQP4RJsmBxcjcanxGJ3QDEXED8GVnBbyA+B8R9QKzLgBs0QDX+R5dgYiAOvMGl+R8SXxWIW3EYIAzEP7FJpAPxVCC+hhSQJAH0WHhLQB1e/+8FYltSbAdFYwsQXwHiY0D8GI9aRmIN1SM1DASA2A6IG4H4PJGB+B+aLsDOQtcAilZmNMU4AXog/gDiEix+R8cMUBczskBzGCgQjwPxMiB+RoQX4AEKEGAAwNE/ATcYfzEAAAAASUVORK5CYII=","views":[],"inPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Data table with possible values","description":"KNIME data table with possible values used to constrain the database SQL query."},{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data","description":"DB Data that will be used during query execution."}],"outPorts":[{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Result Table","description":"KNIME data table with the result from the database and optionally the data columns from the input table."},{"objectClass":"org.knime.core.node.BufferedDataTable","color":"000000","dataType":"Table","optional":false,"name":"Error Table","description":"Table with error message if any, otherwise empty table."}],"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":"Settings","fields":[{"name":"SQL Statement","description":"Enter the SQL-like query here, for example SELECT * FROM table. If the table place holder isn&#39;t changed, then it will be replaced with the query from the database input port. Constant values and any identifier from the database column list, column list and flow variable list can be used in the SQL statement by double clicking the column or variable name.\n<br />\nTo open code completion press <i>&lt;CTRL&gt; &#43; &lt;SPACE&gt;</i> . Table and columns names are only suggested if the metadata is available e.g. shown in the Database Metadata Browser. To perform undo press <i>&lt;CTRL&gt; &#43; Z</i> and for re-do <i>&lt;CTRL&gt; &#43; Y</i> .","optional":false},{"name":"Database Metadata Browser","description":"The Database Metadata Browser allows you to browse the database metadata and to select a table or view. Click the <i>Refresh</i> button at the bottom right to re-fetch the metadata from the database. The data is grouped by database schema and type e.g. view or table. By clicking on an entity it shows contained elements. If you click on a table or view the dialog will fetch the column names and types of the selected element. To select a table or view select the name and click <i>OK</i> or double click the element. To search for a particular table or view enter the name or parts of the name into the search field and click on the <i>Magnifying Glass</i> button or press <i>enter</i> .","optional":false},{"name":"Database Column List","description":"The list contains the columns that are available in the input DB Data object. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).","optional":false},{"name":"Column List","description":"The list contains the columns that are available in the KNIME input table. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).","optional":false},{"name":"Flow Variable List","description":"The list contains the flow variables that are currently available at the node input. Double clicking any of the entries will insert the respective identifier at the current cursor position (replacing the selection, if any).","optional":false},{"name":"Append input columns","description":"If checked, then the columns from the input table will be appended to the output table. Only columns that are used in the looping SQL statement will be appended.","optional":false},{"name":"Include empty results","description":"If checked, then all empty results will be appended to the output table and represented as Missing Cell. All input rows will be retained.","optional":false},{"name":"Retain all columns","description":"If checked, then all columns including columns that are not used in the looping SQL statement will be appended to the output table.","optional":false},{"name":"Fail on error","description":"If checked, then the node will fail if there is any error. Otherwise, the node will continue executing and all errors will be collected in the second output table.","optional":false}]},{"sectionName":"Input Type Mapping","sectionDescription":"This option allows you to define rules to map from database types to KNIME types.","fields":[{"name":"Mapping by Name","description":"Columns that match the given name (or regular expression) and database type will be mapped to the specified KNIME type.","optional":false},{"name":"Mapping by Type","description":"Columns that match the given database type will be mapped to the specified KNIME type.","optional":false}]},{"sectionName":"Output Type Mapping","sectionDescription":"This option allows you to define rules to map from KNIME types to database types.","fields":[{"name":"Mapping by Name","description":"Columns that match the given name (or regular expression) and KNIME type will be mapped to the specified database type.","optional":false},{"name":"Mapping by Type","description":"Columns that match the given KNIME type will be mapped to the specified database type.","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":[{"id":"*GN2SBVbWzuK822qv","factoryName":"org.knime.js.base.node.viz.pagedTable.PagedTableViewNodeFactory","probability":1.0}]}