
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
- Problem with login using Retool
I am using the Appwrite rest api to create an email session from Retool. My next api call is to create JWT. The call is failing because Retool is a closed envir...
- Adding Attributes to User
What is the best way to add attributes for a User? Do I need to create another entity with the attributes since I cant add them in the Auth service. Thx
- Appwrite sites 404
Hello ! When I add a subdomain to a deployed website, it gives me a 404 error on said domain thus making the SSL processus not working and im not able to acces...
