Skip to content
Back

Searching by attribute "name" requires a fulltext index.

  • 0
  • Databases
  • Web
  • Cloud
Dan6erbond
1 Mar, 2026, 19:28

I have a table "products" with a few columns I'm trying to search by, but I get this error:

TypeScript
{
    "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),
  ],
});```
TL;DR
Searching by attribute "name" requires a fulltext index. Table has fulltext indexes but error persists. Possible need for setup time or index length adjustment. Try setting index length higher and check status. Share table structure and indexes.
eldad
1 Mar, 2026, 19:29

please share your table structure and list of indexes

Dan6erbond
1 Mar, 2026, 19:31
Dan6erbond
1 Mar, 2026, 19:31

Sorry! Meant to share this screenshot.

Dan6erbond
1 Mar, 2026, 19:31
eldad
1 Mar, 2026, 19:32

no worries

eldad
1 Mar, 2026, 19:32

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

Dan6erbond
1 Mar, 2026, 19:33

Is there a recommended length (depending on the expected content I suppose?) for FTS indexes?

eldad
1 Mar, 2026, 19:33

yes, it's really up to your use case.

eldad
1 Mar, 2026, 19:34

Nothing Appwrite specific

Dan6erbond
1 Mar, 2026, 19:34

Hmm, when I select Fulltext the length input disappears?

Dan6erbond
1 Mar, 2026, 19:34

Only available for "Key".

eldad
1 Mar, 2026, 19:35

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.

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more