👋 Next.js Conf 2024: Come build, party, run, and connect with us! See all events

Querying and expanding references in Sanity.io

23 replies
Last updated: Feb 13, 2023
For example... I have a doc type "experience" that references another type "Skill". I'm able to see my array of "skills" but when I map over them, the image is undefined
Feb 12, 2023, 12:50 PM
Could you show the query youre using?
Feb 12, 2023, 1:26 PM
sure.
Feb 12, 2023, 1:29 PM
export const experienceQuery = groq`
*[_type == "experience"]
`
Feb 12, 2023, 1:30 PM
This is the simple query, which returns all the experience docs.
Feb 12, 2023, 1:30 PM
Part of those results is this:
Feb 12, 2023, 1:30 PM
This is the type definition for both those document types
Feb 12, 2023, 1:32 PM
This is the result of
experience?.jobFunction?.technologies
I think the issue is the available fields on this don't include
image
, so I guess I'm not clear on how to get the image URL from this reference.
Feb 12, 2023, 1:39 PM
Yeh, you need to expand those references like technology->
Feb 12, 2023, 1:46 PM
If you are manually typing your data i would reccomend checking out groqd where you build your query by creating a validation schema which can then be inferred to ts
Feb 12, 2023, 1:47 PM
can you link me to that? I think I understand what you're saying. I'm not getting enough data with my original query
Feb 12, 2023, 1:48 PM
Also in general i prefer to be explicit with groq queries, noe you are basically ‘fetching everything’
Feb 12, 2023, 1:51 PM
Also highly reccomend this guide https://hdoro.dev/learn-groq
Feb 12, 2023, 1:52 PM
Thanks, I'll look this stuff over.
Feb 12, 2023, 2:02 PM
So it looks like I should be using something like this, which would get me all the experience docs and their data, as well as the expanded references for technologies.

*[_type == "experience"]{
  ...,
  technologies[]->,
}
Feb 12, 2023, 2:30 PM
Annd nope.
Feb 12, 2023, 2:43 PM
this is what I'm trying to expand
Feb 12, 2023, 2:43 PM
hahha, I got it
Feb 12, 2023, 2:58 PM
*[_type == "experience"]|order(dateStarted desc) {
  ...,
    jobFunction {
      technologies[]->
        }
}

Feb 12, 2023, 2:58 PM
Awesome!
Feb 12, 2023, 3:30 PM
I definitely see what you mean by being more targeted. That was my initial query, so now it makes sense more, after expanding those references within the fieldset
Feb 12, 2023, 3:33 PM
*[_type == "experience"]|order(dateStarted desc) {
  ...,
  employmentInformation {
    ...,
    professionalReference[]->
  },
  jobFunction {
    technologies[]->,
      points[]
  }
}
Feb 12, 2023, 3:33 PM
I don't know if this helps, but here's how I'm fetching the image URL and metadata:
"image": image{
  ...,
  ...asset->{
    "palette": metadata.palette,
    "lqip": metadata.lqip,
    url
  }
},
Feb 13, 2023, 3:48 AM

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.

Was this answer helpful?