{"title":"DB Sorter","nodeType":"Manipulator","id":"*eTH6FxdMQbNIhJqB","factoryName":"org.knime.database.node.manipulation.sorter.DBSortNodeFactory","factoryId":"org.knime.database.node.manipulation.sorter.DBSortNodeFactory","path":["DB","Query"],"owner":"knime","ownerAccountId":"account:team:b5f0848f-496d-4e6a-b869-fa3532248db7","description":"<p>This node sorts the DB Data rows according to user-defined criteria. In the dialog, select the columns according to which the data should be sorted. Also select whether it should be sorted in ascending or descending order.</p>\n        ","shortDescription":"This node sorts the DB Data rows according to user-defined criteria.","keywords":["database","sort","by","criteria","ascending","descending","order"],"deprecated":false,"streamable":false,"tags":["DB","Query"],"icon":"data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA3BpVFh0WE1MOmNvbS5hZG9iZS54bXAAAAAAADw/eHBhY2tldCBiZWdpbj0i77u/IiBpZD0iVzVNME1wQ2VoaUh6cmVTek5UY3prYzlkIj8+IDx4OnhtcG1ldGEgeG1sbnM6eD0iYWRvYmU6bnM6bWV0YS8iIHg6eG1wdGs9IkFkb2JlIFhNUCBDb3JlIDUuNi1jMDY3IDc5LjE1Nzc0NywgMjAxNS8wMy8zMC0yMzo0MDo0MiAgICAgICAgIj4gPHJkZjpSREYgeG1sbnM6cmRmPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5LzAyLzIyLXJkZi1zeW50YXgtbnMjIj4gPHJkZjpEZXNjcmlwdGlvbiByZGY6YWJvdXQ9IiIgeG1sbnM6eG1wTU09Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC9tbS8iIHhtbG5zOnN0UmVmPSJodHRwOi8vbnMuYWRvYmUuY29tL3hhcC8xLjAvc1R5cGUvUmVzb3VyY2VSZWYjIiB4bWxuczp4bXA9Imh0dHA6Ly9ucy5hZG9iZS5jb20veGFwLzEuMC8iIHhtcE1NOk9yaWdpbmFsRG9jdW1lbnRJRD0ieG1wLmRpZDowYjM2YWM5Ny01ZWJhLTQwZTctOTE4OS1iYmU4ZDdkMGYyNGUiIHhtcE1NOkRvY3VtZW50SUQ9InhtcC5kaWQ6NUE3RDA5QTM4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcE1NOkluc3RhbmNlSUQ9InhtcC5paWQ6NUE3RDA5QTI4RjgyMTFFNTg1NzhENEEzQzA5OUQ0MUMiIHhtcDpDcmVhdG9yVG9vbD0iQWRvYmUgUGhvdG9zaG9wIENDIDIwMTUgKE1hY2ludG9zaCkiPiA8eG1wTU06RGVyaXZlZEZyb20gc3RSZWY6aW5zdGFuY2VJRD0ieG1wLmlpZDo3ODRGNThCNzgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIgc3RSZWY6ZG9jdW1lbnRJRD0ieG1wLmRpZDo3ODRGNThCODgyMzcxMUU1QjA3NkE2NzlGMUIxMUMyOCIvPiA8L3JkZjpEZXNjcmlwdGlvbj4gPC9yZGY6UkRGPiA8L3g6eG1wbWV0YT4gPD94cGFja2V0IGVuZD0iciI/Pj68vI8AAAC1SURBVHjaYmZgYLgNxI5ALALE94H4GwOJ4D8SBmlOwCKPDBjRaBQDQPgLAQMwxNANqMejmAVNLYjP8BuIzwFxHxDrErAtHc0AEJ+BiYgwgvn5PxaMAlSBuJXUMAA5YyoQX8NhKsmB+JYSA/YAsRYOg//jMqAZiMOBWBbNFqwhjsdVcKCHL86xGSAAxHZA3AjE56kRiH/xpXtCBnwH4kJSciLI5JtAfAWIjwPxMiB+RooBAAEGALaIWz1XvoMjAAAAAElFTkSuQmCC","views":[],"inPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"DB Data to sort","description":"DB Data to apply sorter."}],"outPorts":[{"objectClass":"org.knime.database.port.DBDataPortObject","color":"66002d","dataType":"DB Data","optional":false,"name":"Sorted DB Data","description":"DB Data with sorted 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":"Sorting","description":"A list of sorting critera.\n<ul><li><b>Column</b> : Sort rows by the values in this column. If you set multiple sorting criteria, the table is sorted by the first criterion. The following criteria are only considered, if the comparison by all previous criteria results in a tie.</li><li><b>Order</b> : Specifies the sorting order:\n  <ul><li><b>Ascending</b> : The smallest or earliest in the order will appear at the top of the list. E.g., for numbers the sort is smallest to largest, for dates the sort will be oldest dates to most recent.</li><li><b>Descending</b> : The largest or latest in the order will appear at the top of the list. E.g., for numbers the sort is largest to smallest, for dates the sort will be most recent dates to oldest.</li></ul></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":[{"id":"*d8TQIqNnO3XRVTjQ","factoryName":"org.knime.database.node.io.reader.DBReadNodeFactory","probability":0.75},{"id":"*5nnLXgQCDPb0sDP1","factoryName":"org.knime.database.node.manipulation.filter.row.DBFilterRowNodeFactory","probability":0.25}]}