user_id = data["user_id"]
followed_id = data["followed_id"]
result=None
query=[Query.equal("follower",user_id),Query.equal("following",followed_id)]
try:
result=databases.list_documents(databaseID,followCollectionID,queries=query)
print(result)
except Exception as e:
print(e)
result=None```
when i search one by one query it comes but i actually want to search if the collection has a document which satisfies both the queries how can i do that ?
if i use this syntax i get an index error
What do you mean? You want this?
follower == user id AND following == followed id
Yess i want to see if that exists in the same document
I got a workaround using 2 requests and checking if id matches
It should work...whats the result of the API call?
An error index does not exist
But when called individually it comes
So...did you create 1 index with both the attributes?
No 2 π€ we had to create one idex with both?
In it
Yep!
Let me try that asal
Asap *
Recommended threads
- Can't really use the S3 storage device
hi, I've linked my local MinIO Instance (it's just for testing, not for prod.) to my appwrite instance, when i'm uploading a file it's getting uploaded to the S...
- Next.js SSR Site Times Out on First Visi...
Hey everyone, I'm running a Next.js SSR site on a self-hosted Appwrite server (v1.9.0), and I've noticed a strange behavior that I'm hoping someone can help me...
- Appwrite migration stuck on pending
Migration an existing self hosted 1.9.0 to a new VPS tuning self hosted 1.9.0.. import data recognises the api url, project id and api and then when I create, i...