I'm a newbie at firebase I have implemented a sample app that able to transfer point to each other after transfer success I also added two fields called "sender_name" and "receiver_name" but it's too difficult to get all transitions based on user login I found sample ways to do just add multiple where to it, its work fine if true both but that's not what I want I want whereOr like SQL as an example below
SELECT column1, column2, ...
FROM table_name
WHERE condition1 OR condition2 OR condition3 ...;
any solution help, please
   func getUserTransition(){
        // process
        /*
         1.get all transition from tm_members sender and receiver by current user login 
         2.
         */
        guard let username = self.userSession?.username else {
            return
        }
        print("username in user session : \(username)")
        COLLECTION_TM_TRANSITIONS_UAT
            .whereField("sender_name", isEqualTo: username)
            .whereField("receiver_name", isEqualTo: username)
            .getDocuments { documentSnapshot, error in
            if error == nil {
                guard let value = documentSnapshot?.documents else { return }
           
                self.tmTransitions = value.map { (queryDocumentSnapshot) -> TmTransition in
                    let data = queryDocumentSnapshot.data()
                    let email = data["email"] as? String ?? ""
                    let is_sender = data["is_sender"] as? Bool ?? false
                    let point = data["point"] as? Int ?? 0
                    let username = data["username"] as? String ?? ""
                    let sender_id = data["sender_id"] as? String ?? ""
                    let receiver_id = data["receiver_id"] as? String ?? ""
                    let created_at = data["created_at"] as? Timestamp
                    let sender_name = data["sender_name"] as? String ?? ""
                    let receiver_name = data["receiver_name"] as? String ?? ""
                    print("username : \(email)")
                    return TmTransition(id: queryDocumentSnapshot.documentID, sender_id: sender_id, receiver_id: receiver_id, username: username, is_sender: is_sender, point: point, email: email,created_at: created_at,sender_name: sender_name,receiver_name: receiver_name)
              
                }
              
            }
            else{
                print("error during fetch data ")
            }
        }
    }