Query.search not working when searching for number string

Im encountering an issue while using the Query.search Query, to filter a fulltext string Attribute ("modell") in my database. I have a document in my database with a name containing "T561". When using Query.search("modell", "T56") i get the right document. If I however use the Query Query.search("modell", "56") i won´t get the corresponding document.

To me it seems, that there is an issue, when using a filter, containing no letters. Is this an issue on my side or is this a bug within appwrite.

Here is an example of how i use the Query (obviously this is a temporarily hardcoded Value for debugging purposes)

DocumentList response = await databases.listDocuments(
      databaseId: storeSpecificDatabase,
      collectionId: devicesCollection,
      queries: [
        Query.limit(count),
        Query.offset(offset),
        Query.orderAsc('manufacturer'),
        Query.orderAsc('modell'),
        Query.search("modell", "T56")
      ],
    );

Im Using Appwrite 1.5.1 and the appwrite Flutter SDK version 12.0.0

Help is apreciated. Thanks in advance

This is expected because search does not do a substring match.

Perhaps you can try contains instead

Well thank you for the quick help. That was the solution. I was under the impression that contains is only used for finding a value in an array.

It's substring if used on a string attribute

ah i see... thankyou 🙂