How to Filter out Null Values using GROQ

3 replies

Last updated: May 24, 2022

👋Can I filter out

NULL

values using groq?
I want to use a query like this:

*[_type == "link"] {
  _id,
  title,
  label
}

But if for instance

label

is empty/null, it should be filtered out from the result, instead of showing up as

label: NULL

.
If I do a query like:

*[_type == "link"] {
  ...
}

I get the intended result (except I now query too many unnecessary fields).

May 24, 2022, 9:06 AM

defined(label) =&gt; { label }

May 24, 2022, 9:08 AM

Oh, nice 🙂 !

May 24, 2022, 9:10 AM

Thank you!

May 24, 2022, 9:10 AM

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 started Watch demo

Categorized in

Topic	Categories	Featured	Last Updated
After adding the subtitle and running this code npm run graphql-deploy It does nothing	GraphQL Studio Deploy	Not featured	Sep 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...	Reference Studio	Not featured	Sep 18, 2020
Is it possible to fetch more than one "_type" using GROQ?	GraphQL GROQ Schema	Not featured	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...	GROQ Studio Structure builder	Not featured	Sep 23, 2020
Is there a structure builder example where the format of each preview for the document list is modified?	Schema Previews Structure builder	Not featured	Feb 3, 2021
I have an array of references to a country schema type but it always just returns NULL values for me	Queries Reference Schema	Not featured	Jan 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...	Queries GROQ Images	Not featured	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...	Sanity UI Studio	Not featured	Dec 21, 2020
Hey everyone. I have been coding and may have potentially accidentally deleted something. Does anyone know how to resolve...	Studio	Not featured	Dec 26, 2020
Hello everyone and happy new year :raised_hands::skin-tone-2:, I have a problem with outputting Portable Text :disappointed:...	Portable Text Studio	Not featured	Jan 1, 2021

Topic

Categories

Featured

Replies

Last Updated

After adding the subtitle and running this code npm run graphql-deploy It does nothing

Sep 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...