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

How to Order and Specifically Select Multiple _Types in a Query

5 replies
Last updated: Mar 10, 2022
I have a pretty specific query I’m trying to call, the purpose of this query is to get the 4 most recent “hikes” and the 1 most recent blog “post”. My query looks like this:
*[_type in ["hikes", "post"]]{
  _type == "hikes" => {
    _createdAt,
    body,
    mainImage,
    number,
    people,
    slug,
    title,
    trailHiked -> {
        name,
        difficulty,
        distance,
        rating,
        trailType,
        location
    }
  },
  _type == "post" => {
    title,
    body,
    mainImage
  }
}
I’m currently using
this resource for selecting multiple types in a query, its working so far but how can I specify the 4 most recent hikes (assuming I use 
[0…4]
somewhere) and the most recent post (
[0]
?)?
Mar 10, 2022, 11:12 PM
I think if I were in your situation, I'd use two separate projections wrapped in an object:
`{
  'hikes': *[_type == 'hike'][0...3]{
    _createdAt,
    body,
    mainImage,
    number,
    people,
    slug,
    title,
    trailHiked -> {
        name,
        difficulty,
        distance,
        rating,
        trailType,
        location
    }
  },
  'post': *[_type == 'post'][0]
}`
Mar 10, 2022, 11:28 PM
Oh thats great! I didnt know I could do that
Mar 10, 2022, 11:40 PM
Hmm my hikes portion comes back as an empty array
Mar 10, 2022, 11:44 PM
Hmm my hikes portion comes back as an empty array
Mar 10, 2022, 11:44 PM
ah nevermind it needed to be hikes
Mar 10, 2022, 11:45 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 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.