$sort not working as expected in MongoDB query

Issue Summary

I have this in my mongodb query “$sort”:{“name”:“createdAt”,“direction”: -1} but it doesn’t sort at all. Am I missing something?

Screenshot 2022-03-28 at 9.28.16 AM2136×822 66.9 KB

I added the []
"$sort":[{"name":"createdAt","direction": 1}],
Still doesn’t work.

I think this is covered in the Redash documentation. The key you want is sort not $sort.