Exists - ParadeDB

Legacy Docs: This page describes our legacy API. It will be deprecated in a future version. Please use the v2 API where possible.

Basic Usage

Matches all documents with a non-null value in the specified field. All matched documents get a BM25 score of 1.0.

Will error if the field has not been indexed as a fast field.

SELECT description, rating, category
FROM mock_items
WHERE id @@@ paradedb.exists('rating')
LIMIT 5;

SELECT description, rating, category
FROM mock_items
WHERE id @@@
'{
    "exists": {
        "field": "rating"
    }
}'::jsonb
LIMIT 5;

required

Specifies the field within the document to search for the term.

This query is useful for filtering on NULL values inside a boolean query. For instance, the following code block finds all rows with description matching shoes that have a non-null rating.

SELECT description, rating, category
FROM mock_items
WHERE id @@@ paradedb.boolean(
  must => ARRAY[
    paradedb.term('description', 'shoes'),
    paradedb.exists('rating')
  ]
)
LIMIT 5;

SELECT description, rating, category
FROM mock_items
WHERE id @@@
'{
    "boolean": {
        "must": [
            {"term": {"field": "description", "value": "shoes"}},
            {"exists": {"field": "rating"}}
        ]
    }
}'::jsonb
LIMIT 5;

​Basic Usage

Basic Usage