Build with Sanity MCP in Replit. Prizes up for grabs! Submit by June 14

Use GROQ to order by last name in where name is stored as full name

Order by last name

By Sigurd Heggemsnes


Model

{
  type:"document",
  name:"person",
  fields: [
    {
      name:"name",
      type:"string
    }
  ]
}

Query

*[_type == "person"]|order(string::split(name, " ")[-1], asc)[0...12]

This example is based on having a "person" document type

Contributor

Sigurd Heggemsnes

Developer who loves making life easier for people

Norway

Visit Sigurd Heggemsnes's profile