Hi. I have a collection of documents with some string attributes. This collection have a few similar full-text indexes on these attributes. I have also created one more full-text index for the indernal $id attribute.
Search over $id works differently. It only returns documents when there is a startsWith-like match.
E.g. the given document with $id 12345
will be returned for the search values '12345'
, '123'
, but not for the '2345'
. Is that expected?
Yes, this is expected. See https://github.com/appwrite/appwrite/discussions/5005#discussioncomment-4681079 for details about how search works.
You're right, got it. Thanks for the hint. Worth to mention on the https://appwrite.io/docs/products/databases/queries page, probably.
Recommended threads
- The current user is not authorized to pe...
I want to create a document associated with user after log in with OAuth. The user were logged in, but Appwrite said user is unauthorized. User is logged in wi...
- self-hosted auth: /v1/account 404 on saf...
Project created in React/Next.js, Appwrite version 1.6.0. Authentication works in all browsers except Safari (ios), where an attempt to connect to {endpoint}/v1...
- delete document problems
i don't know what's going on but i get an attribute "tournamentid" not found in the collection when i try to delet the document... but this is just the document...