Watch a live product demo 👀 See how Sanity powers richer commerce experiences

JavaScript Query Params - How to Sort Results Using Params

6 replies
Last updated: Dec 15, 2021
Another question: is there a way to sort results based on query params? Currently I’m doing this:
| order(date ${query.sort})
…where
${query.sort}
is a JavaScript expression inside a template string, but I’m curious if this can be done using params.
Dec 15, 2021, 10:06 AM
Yes. You can do this:
* | order(select(
  $sort == "title" => title,
  $sort == "date" => date,
  _id))
This is like a
switch
statement in JS.
Dec 15, 2021, 10:10 AM
Thank you!
Dec 15, 2021, 10:11 AM
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.
Dec 15, 2021, 10:12 AM
So I should stick with the template literal method for performance, in other words?
Dec 15, 2021, 10:13 AM
If possible. Note that the above trick also breaks our ability to optimize slicing. So if you have this:
*[some filter that returns 1 million documents]
  | order(select(...)) [0..100]
…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.
Dec 15, 2021, 10:17 AM
Thanks for the information!
Dec 15, 2021, 10:17 AM

Sanity.io – build remarkable experiences at scale

Sanity is a customizable solution that treats content as data to power your digital business. Free to get started, and pay-as-you-go on all plans.

Categorized in

Related answers

Get more help in the community Slack

TopicCategoriesFeaturedRepliesLast Updated
After adding the subtitle and running this code npm run graphql-deploy It does nothingSep 15, 2020
how to limit a reference to just one entry in Studio reference input side versus the default as-many-entries-as-you-fill-in-an-array...Sep 18, 2020
Is it possible to fetch more than one "_type" using GROQ?Nov 2, 2020
I want to add a view with the Structure builder (S.view.component) where I list similar documents based on the title. What...Sep 23, 2020
Is there a structure builder example where the format of each preview for the document list is modified?Feb 3, 2021
I have an array of references to a country schema type but it always just returns NULL values for meJan 30, 2021
Hi, I need help with a query for getting the url of an image asset. Here is what I've been trying, but I only get the _ref...Dec 1, 2020
Sanity UI looks brilliant :smiley: Is something like the current date picker possible at the moment? I’m not sure if anicon...Dec 21, 2020
Hey everyone. I have been coding and may have potentially accidentally deleted something. Does anyone know how to resolve...Dec 26, 2020
Hello everyone and happy new year :raised_hands::skin-tone-2:, I have a problem with outputting Portable Text :disappointed:...Jan 1, 2021

Related contributions

Clean Next.js + Sanity app
- Template

Official(made by Sanity team)

A clean example of Next.js with embedded Sanity ready for recomposition.

Cody Olsen
Go to Clean Next.js + Sanity app

Blog with Built-in Content Editing
- Template

Official(made by Sanity team)

A Sanity-powered blog with built-in content editing and instant previews.

Go to Blog with Built-in Content Editing