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


Join the chat
Apr 21, 2023 (5 months ago)
Photo of md5-0f21f25e9053983a0294d82fac1b8112
10:18 AM
Hi 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: 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
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
10:37 AM
Correct, 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.