Hey π
I use this method to create a query array:
let querys: string[] = [];
combinations.forEach(combination => {
querys.push(Query.search('ingredientNames', combination.nameNormalized).toString());
});
Search word is e.g. bohnen_(weiss) . => "search(ingredientNames, [bohnen_(weiss)])" There is also an underscore between bohnen and (weiss) that cannot be displayed here. But entries with "pfefferkoerner_(weiss)" are also found...
That doesn't make any sense to me. π€
Any Idea ?
thanks
Hm, okay. It seems that no special characters or spaces can be used with the ".search" method, otherwise it will separate and search for both?
@VincentGe can you take a look at this?
I believe special characters are not searchable in MariaDB fulltext indexes
This might be related
You may have to be creative with your indexes for searching π
thanks π I dont use special characters anymore and it worked fine.
Recommended threads
- Inviting members while SMTP is disabled ...
Issue: https://github.com/appwrite/console/issues/3125 PR: https://github.com/appwrite/console/pull/3126
- Appwrite Sites: ERR_TOO_MANY_REDIRECTS o...
So, my domain was working perfectly fine with Vercel. I was using cloudflare CDN (still am) but CNAME was DNS-only. I switched over to appwrite, CNAME is still ...
- Invalid type for attribute 'email': emai...
I'm using the node-appwrite SDK to create a table, the column payload looks like this: ```json [{"key":"email","type":"email","required":true, "size": 512}] ``...