Kevins35Original post
Rank 2: Process
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
Summary
Developers are having an issue with `Query.search` function when searching for a number string. The issue seems to occur when the filter contains no letters. The solution is to use `contains` instead of `search` for a substring match.