#community-help

Querying Optional Fields with Non-null Values

TLDR Max asked about querying documents where an optional field is not null. Jason shared a prior discussion link and stated there's no direct filter for null values.

9mo

Join the chat

Mar 23, 2023 (9 months ago)

Photo of md5-ac5d64b63e48fd1a3cf936c3e2221a2c

Max

02:16 PM

Hi ! I would like to query_by a field that is optional. So in the index, the documents where the field=null do not have the field at all. How to query_by where field is not null ?

Photo of md5-8813087cccc512313602b6d9f9ece19f

Jason

02:18 PM

Prior discussion on this: https://typesense-community.slack.com/archives/C01P749MET0/p1678920859745439?thread_ts=1678916915.291589&channel=C01P749MET0&message_ts=1678920859.745439

02:19

Jason

02:19 PM

There’s no filter by null values otherwise directly

Max

03:24 PM

Thanks!

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 3015 threads (79% resolved)

Join Our Community

Similar Threads

Query Regarding Null Field Filtering in Typesense

Luke asked about null field filtering, to which Kishore Nallan provided a link explaining its unavailability.

30mo

Troubleshooting Typesense Filter_by Parameter Issue

Sagar had trouble with the filter_by parameter in Typesense. Kishore Nallan identified issue related to indexing, which resolved part of the issue. Guidance was given for handling null values.

4mo

Troubleshooting Typesense 400 Error with Null Fields

sonu was encountering a 400 error due to null fields during Typesense indexing. Jason suggested upgrading to a recent version, removing null fields, and marking potentially null fields as `optional: true`. gab shared a similar issue and workaround.

31mo