PlugIns JdbcSlim UserGuide 6OutputOptions
If your query defines an alias for a column name like below "firstname" then you must use this name in the header.
| SQLCommand | TestDatabase | select ID, Name as firstname from TestData | SORT SUBQUERY |
| ID?> | firstname? | ||
| 5 | Sarah | ||
| 3 | Tom | ||
If you must use the table column name then add the flag dbUseColumnName
| SQLCommand | TestDatabase | select ID, Name as firstname from TestData | SORT SUBQUERY dbUseColumnName |
| ID?> | Name? | ||
| 5 | Sarah | ||
| 3 | Tom | ||