Complex sql query (for me anyway)

[Teodor]

See my last reply about dynamic column names sent as parameters. Also more on this topic:

Custom Query Parameter Not Working

I have created a ‘Database Custom Query’, and I need to order the results dynamically. Per my screenshots below, if I hardcode the ‘ORDER BY’ value into the query, the results return as expected. However, if I pass a parameter to it instead, it is ignored and the results are ordered by their IDs. Has anyone got any ideas? [Screenshot 2020-01-20 at 11.54.53] [Screenshot 2020-01-20 at 11.55.11] [Screenshot 2020-01-20 at 11.55.49]