HI I'm currently using below code to retrieve the audit log from Appian logs.
queryappianlogs( sqlStatement: "SELECT * FROM login-audit", hasHeader: false() ).data
Discussion posts and replies are publicly visible
The sql statement supports order by. From what I've tested, you can specific a numeric value as the column to order, where that number corresponds with the column in the login-audit csv.
For example, to sort on username (column 2):
queryappianlogs( sqlStatement: "SELECT * FROM login-audit order by 2 asc", hasHeader: false()).data
Hello Justin Watts
Question is not about the Values its about the columns.Example
In Dev - Result set returns something like Datetime, IP Address, Username... In Test - Result set returns something like IP Address, Date time, username. I would like to have resultset in the same order in all the environments.