---
title: "Search Null and Not Null Values"
slug: "search-null-and-not-null-values"
tags: ["Advanced Search", "Filter", "field"]
updated: 2024-10-30T09:46:46Z
published: 2024-10-30T09:46:46Z
canonical: "docs.revealdata.com/search-null-and-not-null-values"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.revealdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Search Null and Not Null Values

You can use the Advanced Search feature to search and filter for metadata fields that are either null (have no value) or not null (contain any value). To perform this search, follow the instructions below:

1. Click on the **Analytics** tab and then click on the **Advanced Search** ![](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/advancednbspsearchnbspnbspnullnbspnbspnotnbspnullnbspvalues-image-znzh65wi.png) option just below the Supervised Learning tab. ![](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/advancednbspsearchnbspnbspnullnbspnbspnotnbspnullnbspvalues-image-zlkjeumq.png)
2. If you do not know the name of the field you want to search against, use the ![](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/advancednbspsearchnbspnbspnullnbspnbspnotnbspnullnbspvalues-image-8m6pfqx0.png) to the right of **brs:mimeType** to view a list of available metadata fields.
3. Once you have the name of the field you want to search, enter the field name on the line below **Keyword Search** to the far left of the **Advanced Search** drop down menu. In this example, we’re searching the field Entity_Money.

![](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/advancednbspsearchnbspnbspnullnbspnbspnotnbspnullnbspvalues-image-vkkvdjsg.png)
4. To find documents where this field is Not Null (has a value), enter “:*” after the field name. Here is an example:

- **Entity_Money:***

1. After entering the search criteria, hit the **Enter** key on your keyboard.
2. Then click on **Search** to execute the search.
3. To find documents where this field is Null (has no value), enter the same search criteria, hit Enter, and then select the **N** or Not option in the Search Pill.

![](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/advancednbspsearchnbspnbspnullnbspnbspnotnbspnullnbspvalues-image-zygv7hzu.png)

The arrow in the above illustration points to an icon that opens the Lucene query syntax.

![](https://cdn.us.document360.io/3e21d801-ca9f-4c51-93db-9cbd32741f3d/Images/Documentation/advancednbspsearchnbspnbspnullnbspnbspnotnbspnullnbspvalues-image-jlksr9k9.png)

## Related

- [Advanced Search](/advanced-search-1.md)
- [Reveal-Brainspace Connector Guide](/reveal-brainspace-connector-guide.md)