How to make the "order by" statement work in the gateway-sql plugin? Marie Francesca De Vera June 30, 2017 23:10 Follow You need to define the columns and type in the table definition When you define the source tables in the gateway-sql plugin, ensure that you define the columns and its corresponding type: Once defined, the sorting should take place automatically.select * from T2 order by value Related articles How do I use multiple data sources in gateway SQL Gateway SQL - Using XPath Sources Why does gateway-sql not return column data? How to group multiple rows of data on a dataview to make it easier sending email alerts or copying to create reports? What does the error message "ERROR: SQL Error in Stage: 'Extract xxx' mean in gateway sql? Comments 0 comments Please sign in to leave a comment.