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

How to Transform the Output of a String Inside GROQ

6 replies
Last updated: Jun 23, 2021
Hey all, is it possible to transform the output of a string (inside GROQ)? I’m building a nav schema which is an array of parent, child references. Parent references are optional and I’m falling back to the title specified as the base “slug” for children.
Trying to achieve something like this…


  *[_type == "navigation"] {
    items[] {
      // Can I "slugify" the "title"?
      "slug": coalesce(page->slug.current, title),
      children[] {
        "slug": page->slug.current,
      }
    }
  }
Happy to “slugify” the value returned for slug but was just wondering about the possibility of doing this inside GROQ itself
Jun 23, 2021, 2:33 AM
i don’t believe there is a pattern for this type of replace/string modification in groq
Jun 23, 2021, 2:34 AM
you could however fetch the first child? to be the default slug
Jun 23, 2021, 2:35 AM
i regularly slugify titles for things like FAQ sections though, probably something similar you are after, but i do that in the frontend.
Jun 23, 2021, 2:36 AM
you could also maybe auto-generate a slug in a hidden custom field if you really don’t want to do it in the frontend and don’t want the client to see it in the editor?
Jun 23, 2021, 2:38 AM
Oooh ok I figured that might be the case. Good tip RE the hidden field, I think I’ll just do it client side though 🙂
Jun 23, 2021, 2:40 AM
yeah more control that way, hiding things never ends well.
Jun 23, 2021, 2:45 AM

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.