[SOLVER] Fulltext search not work in flutter

I use the latest version of Appwriter in flutter but when i setup the fulltext index key for the attribute, I can not search the related keyword basing on the field.
Example: I combine two user id as the string and set it into the field named member_ids, and i use my user id to search but it is not returned for me the result as i expected after i have created the document.

Fulltext search only searches from the beginning of each word, IIUC

Oh

I assume it can work with the text in the everywhere in the sentense

Yeah, I assumed that too, at first! I belief the fulltext search in Appwrite is basically MySQL fulltext search.

• Each term to be searched (in the database) should be comma separated.
• Each searched term needs to be at least three characters
• Common English words (like, and, but, etc) will be ignored

So can i format text for searching with the word place anywhere in the sentense?

You should be able to search for any word within a sentence, I believe. Your search term just needs to start at the beginning of the word.

So “sent” would find “sentence”, but “tenc” would not

Because i want to search with the case 'tenc' for simple

Now i use the start with and end with query for searching data

To my knowledge, this is not currently possible

It is unconvinient

Oke thank sir

Hope this can be updated in the future

*inconvenient?

My english is not good so i am sorry for that

So do I! But to my knowledge, this is not an Appwrite limitation - it’s a MySQL (or to be more accurate, MariaDB) limitation

That’s fine - I’m sure my grasp of your native language is far worse than your grasp on mine (English)!

If your issue has been solved, you can mark this post as closed by adding “[SOLVED]” to the beginning of the title

Oke sir

[SOLVER] Fulltext search not work in flutter