Supabase realtime where column equal to val1 or val2
I have same issue as described in this thread https://stackoverflow.com/questions/73679550/how-to-queries-in-supabase-realtime except I want to filter realtime conversations where sender or receiver equals to some value. Is it possible to do 'or' 'message_table:sender=eq.user1 or recveiver=eq.user2'
Stack Overflow
Most of the blogs and stacks suggests below database for chat.
message_table
-id
-message
-conversationId
-sender
-receiverId
conversation_table
-id
-conversationId
Now message_table look like th...
message_table
-id
-message
-conversationId
-sender
-receiverId
conversation_table
-id
-conversationId
Now message_table look like th...