Querying with GROQ in Sanity.io Slack thread
61 replies
Last updated: May 7, 2020
W
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
W
Okay so basically I'm trying to search my data set for certain criterias
Apr 15, 2020, 7:42 PM
W
but my dataset has references to other documents that I need to query also
Apr 15, 2020, 7:42 PM
W
for instance I have a documents that have _type == "dress"
Apr 15, 2020, 7:43 PM
W
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
W
I want to query by the name of the dress and the name of the fabric
Apr 15, 2020, 7:43 PM
W
does that make sense?
Apr 15, 2020, 7:43 PM
W
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
W
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
W
I basically want to do like a search though like `[_type === "dress" && fabricname == "name"]
Apr 15, 2020, 7:46 PM
W
[_type === "dress" && fabricname == "name"]
Apr 15, 2020, 7:46 PM
W
I understand how to do the joins
Apr 15, 2020, 7:46 PM
[_type === "dress" && fabric->name == "name"]
Apr 15, 2020, 7:46 PM
W
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
W
I can do that without joining in the first place?
Apr 15, 2020, 7:47 PM
Yup!
Apr 15, 2020, 7:47 PM
W
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
W
Thank you sir
Apr 15, 2020, 7:49 PM
W
What if my document has an array of properties which has a property that references another document?
Apr 15, 2020, 7:59 PM
W
this works for the join
Apr 15, 2020, 7:59 PM
W
colors[]{color->{name}}
Apr 15, 2020, 7:59 PM
W
but what would be the syntax for that for a conditional?
Apr 15, 2020, 8:00 PM
W
colors[].color->name doesn't work
Apr 15, 2020, 8:00 PM
*[“red” in colors[].color->name]
_refis on the
codekey
Apr 15, 2020, 8:04 PM
W
cool
Apr 15, 2020, 8:12 PM
W
so -> always looks for a _ref?
Apr 15, 2020, 8:13 PM
Correct!
Apr 15, 2020, 8:33 PM
W
Quick one more question
Apr 15, 2020, 9:15 PM
W
so all of this worked and here is my result
Apr 15, 2020, 9:15 PM
W
defaultImage: { asset: { url: '<https://cdn.sanity.io/images/6ci6a8f7/production/3abd50a00ca8269ae3e0fe33a64103e0c2099bc2-1200x1638.jpg>'
}
}
Apr 15, 2020, 9:15 PM
W
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->url
Apr 15, 2020, 9:18 PM
W
Hey Knut, thanks for much for yur time
Apr 16, 2020, 3:56 PM
W
your*
Apr 16, 2020, 3:56 PM
W
I just have one more question
Apr 16, 2020, 3:56 PM
W
I have the following part in my query
Apr 16, 2020, 4:24 PM
W
colors[]{color->{name,"url": image{asset->{url}}}}Apr 16, 2020, 4:24 PM
W
this makes a property called colors which is an array of the following objects
Apr 16, 2020, 4:24 PM
W
{ color: { name: 'Auburn Moon', url: [Object] } }Apr 16, 2020, 4:25 PM
W
I just want it to be
Apr 16, 2020, 4:25 PM
W
colors: [{ name 'Auburn Moon', url: 'string' }, ....]Apr 16, 2020, 4:25 PM
W
nevermind, I figured it out! thx
Apr 16, 2020, 4:31 PM
W
oh, so I have this:
"images": [defaultImage.asset->url]
Apr 16, 2020, 4:32 PM
W
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->url], [])
Apr 16, 2020, 5:00 PM
W
cool, ty
Apr 16, 2020, 7:15 PM
W
Hi, is there a limit to the number of request we can hit
Apr 17, 2020, 6:02 PM
W
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
J
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
K
Not at the moment, but I believe we’re working on a solution for that. Stay tuned!
May 5, 2020, 6:33 AM
J
ok, so what would be the best way to implement searching?
May 5, 2020, 6:33 AM
K
[for the future, it‘s better if you post new questions in the main thread]
May 5, 2020, 6:33 AM
J
kk
May 5, 2020, 6:34 AM
K
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
J
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
Sanity is a 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.