👀 See Sanity in action: Watch product demo now →

Am I right in thinking that it isn’t currently possible to query a random document, or X random documents, of a given type using GROQ?

13 replies
Last updated: Jan 8, 2021
Am I right in thinking that it isn’t currently possible to query a random document, or X random documents, of a given type using GROQ?
Jan 8, 2021, 10:53 AM
I want to store an editable, categorised database of colours in the Studio that are randomly paired with items on the frontend 🙂
Jan 8, 2021, 10:55 AM
Well you can string interpolate and have a dynamic value in your query that'll make it random.
Jan 8, 2021, 11:00 AM
I hope I understand this correctly
Jan 8, 2021, 11:00 AM
Ah of course! So simple… yes you’ve understood perfectly, that hadn’t occurred to me. Thanks Dorell.
Jan 8, 2021, 11:14 AM
good luck Simon. glad to help someone today. 😄
Jan 8, 2021, 11:15 AM
Although! I guess this way I need to perform two queries, one to check the number of existing colours, then the second with numbers generated within the range of possible indexes
Jan 8, 2021, 11:19 AM
The plot thickens…
Jan 8, 2021, 11:19 AM
… but to be honest that’s probably fine for this. I’ll run a test 🙂
Jan 8, 2021, 11:20 AM
I’d take a bite at things rather than eat it whole 😄
Jan 8, 2021, 11:21 AM
Yup, that's the way to do it for now. Here's the feature request https://github.com/sanity-io/GROQ/issues/3
Jan 8, 2021, 11:26 AM
… but to be honest that’s probably fine for this. I’ll run a test 🙂
Jan 8, 2021, 11:20 AM
Yup, that's the way to do it for now. Here's the feature request https://github.com/sanity-io/GROQ/issues/3
Jan 8, 2021, 11:26 AM
I’d take a bite at things rather than eat it whole 😄
Jan 8, 2021, 11:21 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