Skip to content
Watch a live product demo 👀 See how Sanity powers richer commerce experiences
Get help on SlackWatch Sanity demo

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.

Get startedWatch demo

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

Featured
Official

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

Cody Olsen

Blog with Built-in Content Editing
Template

Featured
Official

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