Querying Fields for Null/Undefined/Missing Values
TLDR Emma asked if filtering fields by nullity is possible. Jason provided a workaround link, which Emma appreciated.
Powered by Struct AI
1
3
4mo
Aug 05, 2023 (4 months ago)
Emma
Emma
09:08 PMIs it possible to filter by a field being null/undefined/missing?
Jason
Jason
09:12 PMNot directly, but hereโs a workaround: https://threads.typesense.org/kb/2L10b
Emma
Emma
09:14 PMAh, appreciate that!
1
Typesense
Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI
Indexed 3015 threads (79% resolved)
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.
3
30mo
Handling Unknown Fields in Search Query Schema
Adrian faced an issue when an unknown field disrupted search queries. Jason informed them that Typesense must validate all fields before filtering and suggested preemptively including these fields as optional in the schema.
4
2mo
Querying Optional Fields with Non-null Values
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.
4
9mo