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 What is a History Chart and how does it work? How do I use multiple data sources in gateway SQL 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? Gateway SQL - Using XPath Sources Comments 0 comments Please sign in to leave a comment.