How to include referenced document properties in a JavaScript client fetch for a "location" document

15 replies

Last updated: Dec 4, 2020

when using the javascript client and I fetch a "location" document with referenced "labels" array, the labels array doesn't contain most of the referenced documents properties. How do I get it to include them?

Dec 3, 2020, 10:17 PM

Is your query using the dereferencing operator (

-&gt;

Dec 4, 2020, 2:04 AM

I tried, that didnt work at all

Dec 4, 2020, 6:41 AM

query looks like this

Dec 4, 2020, 6:41 AM

*[_type == "location"]{
          _id,
          name,
          description,
          image,
          location,
          characters,
          labels
      }

Dec 4, 2020, 6:41 AM

schema for locations is like this

Dec 4, 2020, 6:42 AM

{
      title: 'Location',
      name: 'location',
      type: 'document',
      fields: [
        { name: 'name', Title: 'Name', type: 'string' },
        { name: 'description', Title: 'Description', type: 'text' },
        { name: 'location', Title: 'Location', type: 'geopoint' },
        { name: 'image', title: 'Image', type: 'image' },
        {
          title: 'Characters',
          name: 'characters',
          type: 'array',
          of: [{
            type: 'reference',
            to: [{type: 'character'}]
          }]
        },
        {
          title: 'Labels',
          name: 'labels',
          type: 'array',
          of: [{
            type: 'reference',
            to: [{type: 'label'}]
          }]
        }
      ]
    }

Dec 4, 2020, 6:42 AM

at the moment I get labels in the result but its only the meta keys

Dec 4, 2020, 6:43 AM

when i change it to labels-> I get no labels at all

Dec 4, 2020, 6:44 AM

Would you expect this to work?

Dec 4, 2020, 8:31 AM

*[_type == "location"]{
          _id,
          name,
          description,
          image,
          location,
          characters,
          labels-&gt;
      }

Dec 4, 2020, 8:31 AM

Hi Richard, could you try something like this?

*[_type == "location"]{
          _id,
          name,
          description,
          image,
          location,
          characters,
          "labels": labels[]-&gt;{
            ...
          }
      }

Dec 4, 2020, 12:16 PM

perfect! that works thanks!

Dec 4, 2020, 12:24 PM

is that approach documented anywhere? I don't recall seeing that anywhere

Dec 4, 2020, 12:24 PM

You could probably also just use

labels[]-&gt;

alone - the issue was there: it's an array so it needs

[]

🙂 You can find some examples over here: https://www.sanity.io/docs/query-cheat-sheet#object-projections-4ff061cc51e4

Dec 4, 2020, 12:31 PM

oh thats handy thanks!

Dec 4, 2020, 12:33 PM

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 started Watch demo

How to include referenced document properties in a JavaScript client fetch for a "location" document

Sanity.io – build remarkable experiences at scale

Categorized in