Typesense Negation Operator and NULL Value Support
TLDR Richard asks about negating a bracket part and Typesense support for NULL values. Kishore Nallan confirms no negation on the whole block and null values not being indexed.
Powered by Struct AI
1
2
5mo
Solved
Apr 21, 2023 (5 months ago)
Richard
Richard
10:18 AMHi all,
i'm new in the typesense world. Currently i'm implementing the search in shopware 6 and i have got one understanding problem.
It is correct, that we can't negate a bracket part? for example:
And it is correct, that typesense doesn't support a
Version:
i'm new in the typesense world. Currently i'm implementing the search in shopware 6 and i have got one understanding problem.
It is correct, that we can't negate a bracket part? for example:
fieldA:=1 && !(fieldB:=2 && fieldC:=3)
And it is correct, that typesense doesn't support a
NULL
value? Currently i'm using a NULL string for that.Version:
typesense/typesense:0.24.1
Kishore Nallan
Kishore Nallan
10:37 AMCorrect, there is no negation operator on the whole
( )
block. And null
values are just not indexed, so it's not possible to filter on them since they don't exist in the index.1
Typesense
Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI
Indexed 2779 threads (79% resolved)
Similar Threads
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.
21
2mo
Solved
Querying Null and String Values in Typesense.
Andrew wondered if they could look for non-null and string values in Typesense, but Jason explained a workaround by creating a new boolean field at indexing time.
2
8mo
Solved
Querying Empty Strings in Typesense Cloud - Collection Search
Loic wanted to query empty strings in Typesense, but Jason explained this needs to be done when indexing as Typesense doesn't support querying blank keys.
4
12mo