I have a table "products" with a few columns I'm trying to search by, but I get this error:
{
"message": "Searching by attribute \"name\" requires a fulltext index.",
"code": 400,
"type": "general_query_invalid",
"version": "1.8.1"
}```
My table does have fulltext indexes configured, so I'm not sure why I'm still getting this error - do they take some time to get setup? And how can I see the status? Are they available in the Free plan?
My code:```ts
const res = await tables.listRows<Products>({
databaseId: process.env.NEXT_PUBLIC_DATABASE_ID!,
tableId: process.env.NEXT_PUBLIC_PRODUCTS_TABLE_ID!,
queries: [
Query.equal("userId", user.$id),
...(search
? [
Query.or([
Query.search("name", search),
Query.search("brand", search),
Query.search("category", search),
]),
]
: []),
Query.select(["*", "units.*"]),
...orderQueries,
Query.orderAsc("$updatedAt"),
Query.orderAsc("$createdAt"),
Query.offset((page - 1) * perPage),
Query.limit(perPage),
],
});```
please share your table structure and list of indexes
Sorry! Meant to share this screenshot.
no worries
It seems a bit off to have the index length set to 0, but not sure if this is the issue. I would recommend trying to set it to a higher value, but I'll share this with the team
Is there a recommended length (depending on the expected content I suppose?) for FTS indexes?
yes, it's really up to your use case.
Nothing Appwrite specific
Hmm, when I select Fulltext the length input disappears?
Only available for "Key".
Got it, it might be it really is not relevant and we shouldn't even show it, but I'm checking with our databases team to be sure. They will have more insights.
Recommended threads
- function subdomain ssl certs
The generated subdomain isn't getting a valid ssl cert, I was wondering if appwrite automatically generates one or uses a wildcard for *.functions.domain.com? ...
- Issue with usage
I have a weird problem, my project on appwrite was using avarage 5-10k reads a day, it was okay, but suddenly last 7 days, reads are about 60k a day, the code h...
- π Realtime Flutter SDK Crash β Realtime...
**Summary** When using Appwrite Cloud with the Flutter SDK (latest appwrite release: 21.4.0), Realtime crashes with: ```Unhandled async error: type '_Map<String...