#community-help

Query Language 'Or' Filtering Feature Discussion

TLDR Iulian asked for ‘or’ filtering in the query language with Typesense. Kishore Nallan informed it's targeted for the year end. Jason provided a temporary workaround.

26mo

Join the chat

Nov 04, 2021 (26 months ago)

Photo of md5-790da83a2e75e1863cd6e991ddc09073

Iulian

03:44 PM

Hi! Is there an equivalent to the or filtering condition? I want to return documents that have either a property or another one and I couldn't find it in the docs. Thanks!

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

03:45 PM

👋 Currently it's only possible to do OR within a given field, like age: [20, 30, 40] but not across fields, but we have an issue open for that and it's an important one for us to address soon.

Iulian

03:49 PM

Hi, thanks for the fast reply! Is there any ETA? Just so I know if I need to completely rethink my system or not. Thanks for this amazing product!

Kishore Nallan

04:11 PM

We want to target by end of the year. It's a major feature and will require extending the query language to support ORing.

Photo of md5-8813087cccc512313602b6d9f9ece19f

Jason

05:15 PM

Iulian Here's a work-around in the meantime using multi_search: https://github.com/typesense/typesense/issues/281#issuecomment-948179523

Iulian

06:27 PM

Thank you! That's really helpful!

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 3005 threads (79% resolved)

Join Our Community

Similar Threads

Queries on String Sorting, Filter_by Operators and Typesense updates

Ishan asked about OR operators in TypeSense's filter_by fields and string sorting. Kishore Nallan clarified these functionalities. A workaround was proposed for cross-field ORs by Jason. This is on TypeSense's mid-term roadmap.

23mo

Typesense Complex Filtering Syntax Queries

J asked about developing complex filter queries in Typesense. Kishore Nallan stated that Typesense doesn't currently support this feature, but it might be added in the future.

35mo

Usage and Modification of Dynamic Routes in Typesense Documents

Ethan needed a way to perform exact queries through two fields in Typesense documents. Kishore Nallan demonstrated its possibility using the "filter_by". An issue was resolved via recommending that fields in 'query by' should be a string type.

11mo