#community-help

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
Join the chat
Apr 21, 2023 (5 months ago)
Richard
Photo of md5-0f21f25e9053983a0294d82fac1b8112
Richard
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.

1