[SOLVED] AppwriteException: Index not found: created_by,category

But how to merge fields into one and then use that inside Query while listing documents?

After upload your function to appwrite, you can add events on it (https://appwrite.io/docs/events)

So, each time you add/update document on your collection, function will parse fields and concat them to one

But 'created_by' and 'category' are 2 different things represent different values.

If you don't want compute search index, you can already search on it

Depends of what you want. Title of post means you want to search with on query on created_by and category, no ?

const getIdeas = databases.listDocuments("DATABASE_ID", "COLLECTION_ID",
            [
                Query.equal("created_by", [userId.userId.userId]),
                Query.equal('category', [category])
            ])

Here it's an AND query, wich don't use fulltext index cause it's equal and not search

Or am I tired and didn't understand?

Yes, actually it's catergory name

So, do I need to change the fulltext to key?

But that's not working

Try to remove createdby and category index, and create one wich include this two attributes ?

One index can't include both of the attributes.

Are you on cloud instance ?

Yes

For that I thinks. need confirmation from @Steven or others. If I try on 1.3.4, with https:://www.xxx//collections/test/documents?queries[]=equal(created_by, "abc")&queries[]=equal(category, "def") I've result, with or without index

Oh

You only need a full text index if you're using the search query. In your case, you should probably be using 1 key index with both attributes

In 1.3.4, we removed the requirement to have indexes

But wasn't that required due to performance concerns?

Ya but we decided to take a different approach

1 index key with both attributes? How that's possible?

You just add multiple attributes. You can do it in the console

Oh yeah.

Thanks. It's working fine now

[SOLVED] AppwriteException: Index not found: created_by,category