Hi, I am trying to get the latest messages and then sort these messages based on one of their fields(i.e. name in this case). I tried the following. It ran but the sorting didn't happen. Any idea of what I am doing wrong? Thanks in advance for any help.
select tmp.name, tmp.overallStatus from (
SELECT name, overallStatus FROM "sites"
ORDER BY "@timestamp" DESC
LIMIT 80) tmp
ORDER BY tmp.name asc