#community-help

Clarification and Solution for 'not equals filter_by' Configuration

TLDR Alex asked about filter syntax in Typesense. Kishore Nallan clarified that the version being used caused the issue and offered to upgrade their dev cluster to resolve it.

25mo

Join the chat

Oct 28, 2021 (25 months ago)

Photo of md5-faf0fdba0b6739a6706f05c15b6738c6

Alex

10:13 AM

Hi there! I am trying to use the new “not equals filter_by” configuration. I can’t make it work by using the syntax provided in the docs - filter_by=author:!= JK Rowling . However, i think it works with this syntax - filter_by=author:-= JK Rowling . Are the docs wrong or do i have issues with my setup? Thanks!

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

10:14 AM

👋 May I know what version of Typesense you are using? You can hit /debug end-point to find that.

10:28

Kishore Nallan

10:28 AM

filter_by=author:!= JK Rowling is the correct syntax, though we experimented with the "-" very early on, with some debug builds but it was never published. When you use :-= it will just be treated equals since everything after : will be treated as part of filter value and during tokenization, those special characters will be dropped.

11:13

Kishore Nallan

11:13 AM

Alex

Alex

11:28 AM

Hi Kishore!
{"state":1,"version":"0.21.0.rc7"}

11:28

Alex

11:28 AM

:-= works though 😮

Kishore Nallan

11:28 AM

Ah that must be it. It's an early RC build, which might have been rolled out for some other reason which also happened to have the early design for exclusion filters.

Alex

11:29 AM

Oh 😄

Kishore Nallan

11:29 AM

Similar Threads

Upgrading Typesense to Solve Syntax Error

Ken encountered an issue with Typesense search enhancements on their site and Jason suggested an upgrade. They also discussed the possible downtime and finalized the process.

11mo

Resolving Multilingual Search Function in Typesense Software

Bill is having difficulty with multilingual search functionality in Typesense software. Developer Kishore Nallan suggested setting a language locale and provided a demo build. The build solution had some issues, and after multiple rounds of software updates and troubleshooting, the problem still persists.

23mo

Resolving Issues with Infix and Prefix in Query Searches

Daren struggled with searches missing values in production. Jason and Kishore Nallan offered insights and created new features to help solve the problem, which was then tested and deployed by Daren.

3mo

Handling Kinesis Stream Event Batching with Typesense

Dui had questions about how to handle Kinesis stream events with Typesense. Kishore Nallan suggested using upsert mode for creation/update and differentiating with logical deletion. After various discussions including identifying and resolving a bug, they finalized to introduce an `emplace` action in Typesense v0.23.

22mo

Resolving 'Sort by String Property' Error in Typesense

Ahmad was unable to sort by a string property on Typesense. Jason helped diagnose the issue, instructed the user to upgrade from their side, and enabled the sorting feature in the user's schema.

22mo