#community-help

Refining Typesense Query to Exclude Specific IDs

TLDR Andrew was manually ignoring chat IDs in their Typesense query, wondering if there was a better approach. Jason confirmed the approach was correct but suggested simplifying by generating the IDs in an array format.

9mo

Join the chat

Dec 12, 2022 (9 months ago)

Photo of md5-7766f890de99fa72a6d81315691a6758

Andrew

05:41 PM

ok so the way i've been doing this screams incorrect but i didnt find anything on the docs.

So I have a list of strings, 'ignoreIds'. To make sure the resulting query does not have a chatId in this list, i do the following:


String ignore = '';
    //for each chatId, add it to a string that follows the form 'typsenseId:chatId || '
    for (String chatId in ignoreIds) {
      //if chatId is not the last element in the list, add ' || '
      if (chatId != ignoreIds.last) {
        ignore += 'chatId:!=$chatId && ';
      } else {
        //if chatId is the last element in the list, do not add ' || '
        ignore += 'chatId:!=$chatId';
      }
    }

then in the query i have

'filter_by': '(senderId:$userId || receiverId:$userId) && pending:false && ($ignore)',

So that way the id's are ignored. It feels like theres a better way to do this tho lol

Photo of md5-8813087cccc512313602b6d9f9ece19f

Jason

05:45 PM

Typesense does not have a way to reference sub queries like in SQL, so your general approach of listing out each ID would indeed be the way to do it.

You can simplify the last $ignore part by generating it in this format: chatId:!=[id1,id2,id3]

Typesense

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

Indexed 2764 threads (79% resolved)

Join Our Community Manage subscription

Similar Threads

Resolving Typesense Error in Netlify Deployment

Bryan encountered a Typesense error during a Netlify deployment. Jason and Damian determined the problem lay with array signatures and executed a fix. Bryan confirmed this resolved the issue.

22mo

Querying TypeSense: Exclude Certain IDs from Array Field

Andrew asked if it's possible to exclude specific ids from an array in TypeSense, like Firestore's not-in array. Jason confirmed it's possible and shared how to do it, in addition to a reference link.

11mo

Querying with Not-in in Typesense

Masahiro inquired about using not-in queries in Typesense. Kishore Nallan explained how to conduct such queries by using the "-" operator in the query string, and assisted Masahiro with issues stemming from a high number of exclusion tokens. The problem was eventually resolved by switching to the `multi_search` endpoint.

29mo