Resolving 'not equals filtering' Error on 'id' Field
TLDR Andrew had a problem with filtering on the 'id' field. Jason suggested duplicating the value in a different field and confirmed Daniel's understanding about the fix.
2
Oct 19, 2022 (14 months ago)
Andrew
03:48 PM‘filter_by’: ‘id:!{ids}, but it throws ‘not equals filtering is not supported on the ‘id’ field. Is this a bug?
Jason
03:54 PMid
field (since it’s an internal field used by Typesense). If you duplicate the same value in a different field, you should be able to do this1
Daniel
03:59 PM"facet": true
in the schema for the negation to work Jason?Jason
04:00 PM1
Typesense
Indexed 3015 threads (79% resolved)
Similar Threads
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.
Trouble with 'q' Parameter in Typesense query
ryosuke_shiomi was having trouble with a Typesense query involving the 'q' parameter. Kishore Nallan suggested a temporary workaround and proposed using the latest builds to fix the issue. The solution was under trial at the end of the thread.
Resolving 'Cannot use `id` as a query by field' error in Typesense
Alberto was encountering a 'Cannot use `id` as a query by field' error in Typesense. Jason clarified that the 'id' field is used internally and suggested duplicating data in a new field for searching.