JavaScript Query Params - How to Sort Results Using Params

Another question: is there a way to sort results based on query params? Currently I’m doing this:
…where

${query.sort}

is a JavaScript expression inside a template string, but I’m curious if this can be done using params.

Yes. You can do this:
This is like a

switch

statement in JS.

Thank you!

The downside is that this code path is not optimized at the moment. All the documents will be loaded into memory and sorted first, which can be inefficient if you have a lot of documents. How inefficient depends on the size of the documents and so on, so I can’t give you an exact number. But I would recommend not doing it unless you know that the number of documents (after filtering) is less than 1,000 or 1MB.

So I should stick with the template literal method for performance, in other words?

If possible. Note that the above trick also breaks our ability to optimize slicing. So if you have this:
…then the slow/inefficient ordering will happen on those 1 million documents, even though you’re only extracting 100. With a normal

order()

, we can slice while sorting, which is much faster.

Thanks for the information!