How to do reference access only if the object in an array is a reference.

[choutkamartin]

Hi!

I'm kinda new to GROQ. I would like to ask how can I query the following correctly:

export default {
  type: "object",
  name: "menuItem",
  title: "Sub-menu",
  fields: [
    { title: "Menu text", name: "text", type: "string" },
    {
      title: "Menu items",
      name: "menuItems",
      type: "array",
      of: [
        {
          type: "reference",
          title: "Child page",
          description: "Pick a page from the dropdown list below",
          to: [
            {
              type: "page",
            },
          ],
        },
        { type: "menuItem" },
      ],
    },
  ],
};

When I query the schema this way:

export const headerQuery = groq`
*[_type == "menuItem"][0] {
  menuItems[]->
}
`;

I get this:

{
  menuItems: [
    {
      _createdAt: '2023-02-04T20:02:02Z',
      _id: 'b8f7ef0d-807f-48d5-9f3a-1136982896b7',
      _rev: 'NIo0EorZ2fqE7CVJse1cHW',
      _type: 'page',
      _updatedAt: '2023-02-04T21:52:19Z',
      name: 'Dotace',
      pageBuilder: [Array],
      slug: [Object]
    },
    null
  ]
}

The array can contain a normal object or an reference to page. However, if it's not a reference, then of course, the query returns null on the object that is not a reference. Can I somehow do some kind of if statement inside GROQ? (If type == reference, then do reference access otherwise do nothing and only return the object.

Thanks 🙂

[FilipBartos]

I was dealing with the similar thing and found this:

https://www.sanity.io/schemas/projection-of-a-reference-item-in-a-deeplinked-optional-array-69e62a8c :)

Maybe this is what you are looking for?

[fennadew]

For everyone who is still wondering how to do this:

export const headerQuery = groq`
*[_type == "menuItem"][0] {
  menuItems[]{
    _type == 'menuItem' => {
      ...,
    },
    _type == 'reference' => @->{...}     
  }
}
`;