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

Filter Blog Post Query Based on Referenced Tag Names

6 replies
Last updated: Apr 13, 2021
Hello, I am trying to work with GROQ to get some information.For each of my "blog post" document types, there are 3 "tag" document types referenced. I would like to filter my "blog post" query based on its referenced "tag" names. (edited) 
If anyone has any ideas on how I might make this work, I'm all ears. Here is my current implementation:

*[_type == "post"] // && tags[]->tag == "Tutorial" (this doesn't work)
{
  'slug': slug.current, 
  title, 
  'date': _createdAt, 
  subtitle,
  'tags': tags[]->{tag, 'color': tagColor.hex, description, 'slug': slug.current},
} 
| order(_createdAt desc)
I posted in
groq but still haven't gotten any feedback
Apr 13, 2021, 2:41 PM
For checking against arrays, it's best to use the 
in
operator.
Something like this might be what you're looking for (I typically would key off of the _id instead of the tag string, but the tag string is nicely readable)


*[_type == "post" && "Tutorial" in tags[]->tag]

Apr 13, 2021, 2:59 PM
That will see if the string "Tutorial" is in the array that's generated by tags[]->tag (which will be an array of all the tag strings).
If you use the id instead (which will protect agains the tag string changing), you'd modify the filter to look more like this

*[_type == "post" && "some-long-id-string" in tags[]._ref]
(you'd no longer need to "de-reference" the tags, since the 
_ref
matches the Tag document ID
Apr 13, 2021, 3:02 PM
For checking against arrays, it's best to use the 
in
operator.
Something like this might be what you're looking for (I typically would key off of the _id instead of the tag string, but the tag string is nicely readable)


*[_type == "post" && "Tutorial" in tags[]->tag]

Apr 13, 2021, 2:59 PM
user T
oh i see! i was essentially trying to compare two arrays. so is there a way to check if multiple tags match like 
["Tutorial", "Azure"] in tags[]->tag
Apr 13, 2021, 4:08 PM
Unfortunately, there's no array intersections, so the syntax would be:
("Tutorial" in tags[]->tag || "Azure" in tags[]->tag) // OR
("Tutorial" in tags[]->tag && "Azure" in tags[]->tag) // AND
Depending on if you want AND or OR
Apr 13, 2021, 5:28 PM
Thank you!!
Apr 13, 2021, 6:11 PM

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.