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

Querying nested documents with GROQ and implementing search in Sanity.io

61 replies
Last updated: May 7, 2020
Hi, I was wondering if anyone could help me with GROQ?
Apr 15, 2020, 7:39 PM
It’s easier if you tell us what we can help you with :)
Apr 15, 2020, 7:41 PM
Okay so basically I'm trying to search my data set for certain criterias
Apr 15, 2020, 7:42 PM
but my dataset has references to other documents that I need to query also
Apr 15, 2020, 7:42 PM
for instance I have a documents that have _type == "dress"
Apr 15, 2020, 7:43 PM
and inside the dress documents there's a fabric key that has a _ref to a fabric document htat has a name
Apr 15, 2020, 7:43 PM
I want to query by the name of the dress and the name of the fabric
Apr 15, 2020, 7:43 PM
does that make sense?
Apr 15, 2020, 7:43 PM
like is there anyway I can join all of this stuff and then query off of that query result?
Apr 15, 2020, 7:44 PM
You can probably do this?

*[_type == “dress”]{
  “fabric”: fabric->name
}
Apr 15, 2020, 7:45 PM
yeah that's for the join, right?
Apr 15, 2020, 7:46 PM
You can learn more about joins here https://www.sanity.io/docs/groq-joins
Apr 15, 2020, 7:46 PM
I basically want to do like a search though like `[_type === "dress" && fabricname == "name"]
Apr 15, 2020, 7:46 PM
[_type === "dress" && fabricname == "name"]
Apr 15, 2020, 7:46 PM
I understand how to do the joins
Apr 15, 2020, 7:46 PM
[_type === "dress" && fabric->name == "name"]
Apr 15, 2020, 7:46 PM
I want to be able to do conditionals on a document and the document that are referenced
Apr 15, 2020, 7:46 PM
Same syntax :)
Apr 15, 2020, 7:47 PM
I can do that without joining in the first place?
Apr 15, 2020, 7:47 PM
Yup!
Apr 15, 2020, 7:47 PM
Ok, gonna try it real quick
Apr 15, 2020, 7:47 PM
Covered in the “semijoins” section here https://www.sanity.io/docs/groq-joins#semijoins-662d6d368945
Apr 15, 2020, 7:48 PM
Thank you sir
Apr 15, 2020, 7:49 PM
What if my document has an array of properties which has a property that references another document?
Apr 15, 2020, 7:59 PM
this works for the join
Apr 15, 2020, 7:59 PM
colors[]{color->{name}}
Apr 15, 2020, 7:59 PM
but what would be the syntax for that for a conditional?
Apr 15, 2020, 8:00 PM
colors[].color->name doesn't work
Apr 15, 2020, 8:00 PM
*[“red” in colors[].color->name]
Provided the 
_ref
is on the 
code
key
Apr 15, 2020, 8:04 PM
cool
Apr 15, 2020, 8:12 PM
so -> always looks for a _ref?
Apr 15, 2020, 8:13 PM
Correct!
Apr 15, 2020, 8:33 PM
Quick one more question
Apr 15, 2020, 9:15 PM
so all of this worked and here is my result
Apr 15, 2020, 9:15 PM
defaultImage: {
  
asset: {
   
url: '<https://cdn.sanity.io/images/6ci6a8f7/production/3abd50a00ca8269ae3e0fe33a64103e0c2099bc2-1200x1638.jpg>'
  
}
 
}
Apr 15, 2020, 9:15 PM
is there anyway to take that url out of that nested structure and have it on a parent property?
Apr 15, 2020, 9:15 PM
"imageUrl": defaultImage.asset.url

Apr 15, 2020, 9:17 PM
or probably:
"imageUrl": defaultImage.asset-&gt;url

Apr 15, 2020, 9:18 PM
Hey Knut, thanks for much for yur time
Apr 16, 2020, 3:56 PM
your*
Apr 16, 2020, 3:56 PM
I just have one more question
Apr 16, 2020, 3:56 PM
I have the following part in my query
Apr 16, 2020, 4:24 PM
colors[]{color-&gt;{name,"url": image{asset-&gt;{url}}}}
Apr 16, 2020, 4:24 PM
this makes a property called colors which is an array of the following objects
Apr 16, 2020, 4:24 PM
{ color: { name: 'Auburn Moon', url: [Object] } }
Apr 16, 2020, 4:25 PM
I just want it to be
Apr 16, 2020, 4:25 PM
colors: [{ name 'Auburn Moon', url: 'string' }, ....]
Apr 16, 2020, 4:25 PM
nevermind, I figured it out! thx
Apr 16, 2020, 4:31 PM
oh, so I have this: 
"images": [defaultImage.asset-&gt;url]
Apr 16, 2020, 4:32 PM
how can I have it return an empty array if nothign is in there? instead of [null]
Apr 16, 2020, 4:32 PM
try
"images": coalesce([defaultImage.asset-&gt;url], [])

Apr 16, 2020, 5:00 PM
cool, ty
Apr 16, 2020, 7:15 PM
Hi, is there a limit to the number of request we can hit
Apr 17, 2020, 6:02 PM
Like do you recommend making a backend endpoint to hit your endpoint and add a caching service to limit the amount of times the sanity endpoint gets hit?
Apr 17, 2020, 6:11 PM
Here’s the details - we also offer caching on CDN https://www.sanity.io/docs/technical-limits
Apr 17, 2020, 6:19 PM
Hi Knut, I was wondering if there's a way to remove case sensitivity while searching for something in a query?
May 4, 2020, 10:23 PM
Not at the moment, but I believe we’re working on a solution for that. Stay tuned!
May 5, 2020, 6:33 AM
ok, so what would be the best way to implement searching?
May 5, 2020, 6:33 AM
[for the future, it‘s better if you post new questions in the main thread]
May 5, 2020, 6:33 AM
kk
May 5, 2020, 6:34 AM
If you hit the wall with GROQ, you can also look at dedicated search services, like https://www.sanity.io/blog/indexing-in-algolia-using-serverless-functions-and-observables
May 5, 2020, 6:34 AM
Thanks for this, quick question. I have to run GROQ queries to get the data shaped into a certain format, how can I stream this with using the client rather than the export API so I can leverage observables?
May 7, 2020, 6:00 PM

Sanity– build remarkable experiences at scale

The Sanity Composable Content Cloud is the modern headless CMS 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.