Typesense Cloud Filter Expression Issue
TLDR Samuel experienced a "Filter expression is not valid" error on a previously working query. Kishore Nallan assisted in troubleshooting and discovered it was a Scoped Search token formatting issue on Samuel's end.
2
Jun 09, 2023 (6 months ago)
Samuel
08:45 AMFilter expression is not valid.
on queries we didn't change in any waySamuel
08:46 AMKishore Nallan
08:46 AMKishore Nallan
08:48 AMKishore Nallan
08:48 AMSamuel
08:49 AMSamuel
08:50 AMSamuel
08:50 AMKishore Nallan
08:50 AMKishore Nallan
08:50 AMSamuel
08:51 AMSamuel
08:52 AMSamuel
08:52 AMKishore Nallan
08:53 AMhttps://cloud.typesense.org/clusters/<CLUSTER_ID>/collections/<COLL_NAME>/documents/search
Kishore Nallan
08:53 AMSamuel
08:54 AMKishore Nallan
08:55 AMKishore Nallan
08:57 AMSamuel
08:57 AMfilter_by: properties.WORK.assignee.value:=[MY1F91qSWDVS3YEdFuMId0mBCcf1]
Kishore Nallan
08:59 AMfilter_by=properties.WORK.assignee.value:=[MY1F91qSWDVS3YEdFuMId0mBCcf1]
But the UI I think is having trouble with that. I tried
filter_by=properties.WORK.assignee.value:[MY1F91qSWDVS3YEdFuMId0mBCcf1]
which works but returns no results. Let me try against your API directly. Can I have your permission for that?
1
Samuel
08:59 AMKishore Nallan
09:02 AMSamuel
09:02 AMSamuel
09:03 AMSamuel
09:03 AMKishore Nallan
09:03 AMSamuel
09:03 AMSamuel
09:04 AMKishore Nallan
09:04 AMSamuel
09:04 AMKishore Nallan
09:04 AMSamuel
09:04 AM1
Typesense
Indexed 3005 threads (79% resolved)
Similar Threads
Phrase Search Relevancy and Weights Fix
Jan reported an issue with phrase search relevancy using Typesense Instantsearch Adapter. The problem occurred when searching phrases with double quotes. The team identified the issue to be related to weights and implemented a fix, improving the search results.
Fixing Multiple Document Retrieval in Typesense
Phil needed an efficient way to retrieve multiple documents by id. Kishore Nallan proposed a solution available in a pre-release build. After some bug fixing regarding id matching by Jason and Kishore Nallan, Phil successfully tested the solution.
Performance Characteristics of Filtering Search Results
Oskar queries the performance difference in filtering search results. Jason clarifies how filters work and provides performance improvement suggestions like increasing vCPUs and sharding the collection. Kishore Nallan explains filter IDs and document ID matching. The thread concludes with discussions on performance tradeoffs in filter implementation.
Docsearch Scrapper Metadata Configuration and Filter Problem
Marcos faced issues with Docsearch scrapper not adding metadata attributes and filtering out documents without content. Jason helped fix the issue by updating the scraper and providing filtering instructions.
Resolving Typesense Cloud Cluster Issue with Cron Job
Issei reported a problem with an unhealthy Typesense Cloud cluster. With the particular help of Jason and Kishore Nallan, they discovered that a problematic cron job was responsible. A solution, using a different endpoint for data export, was agreed on and implemented.