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?

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?

I want to store an editable, categorised database of colours in the Studio that are randomly paired with items on the frontend 🙂

Well you can string interpolate and have a dynamic value in your query that'll make it random.

I hope I understand this correctly

Ah of course! So simple… yes you’ve understood perfectly, that hadn’t occurred to me. Thanks Dorell.

good luck Simon. glad to help someone today. 😄

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

The plot thickens…

… but to be honest that’s probably fine for this. I’ll run a test 🙂

I’d take a bite at things rather than eat it whole 😄

Yup, that's the way to do it for now. Here's the feature request https://github.com/sanity-io/GROQ/issues/3

… but to be honest that’s probably fine for this. I’ll run a test 🙂

Yup, that's the way to do it for now. Here's the feature request https://github.com/sanity-io/GROQ/issues/3

I’d take a bite at things rather than eat it whole 😄