
i'm working on a chat functionality. so in all chat applications, we see a chats list on the left that shows with whom you're chatting or have chatted with. either you're the receiver or the sender, it shows the chat item. so to get a list like this, we need to pass a query where the sender_id
or the recipient_id
is equal to the current user id.
we can do an OR
operation for a value of any attribute by passing an array in the 2nd argument of the equal
method. but what i need here is something like an OR
operation for the name of the attributes and i can't find a way to do that. am i missing something?

my goal above could be achieved by the below SQL
SELECT * FROM chats
WHERE (sender = {currentUser.$id} OR recipient = {currentUser.$id}) ORDER BY timestamp
in case it helps

This is not supported at the moment. See https://github.com/appwrite/appwrite/issues/2740
Recommended threads
- Incremental/Updates based on OG value wh...
I've set up my own SDK accessed as below ```lua DB["userinfo"]["bankaccounts"]:update({ method = "equal", attribute = "userid", values =...
- 🚨 CORS Issues with Web Platform Configu...
Hi! i am new to react and i am making a movie web app as a first project (learning while doing so i barely know stuff now) I've been struggling with CORS errors...
- Relationships. Delete on cascade through...
Hi all!, When I delete a document throught the Apple SDK, on delete cascade is not working. If I delete the document from the console (Cloud), a dialog is show...
