我的查询：

sql.eachRow("select * from mytable where type = 'SUMMARY' and acolumn=${columnValue} order by ${sortColumn} ${sortOrder}") { row ->
                    results << row.toRowResult()
                }

我可以通过对返回的列表进行排序来解决问题,但是如果可能的话,我想在sql语句中执行此操作.这是一个已知的问题吗？

解决方法

sql.eachRow( "select * from mytable where type = 'SUMMARY' and acolumn=${columnValue} order by ${sql.expand(sortColumn)} ${sql.expand(sortOrder)}") { row ->
  results << row.toRowResult()
}