How to make a query to get multiple queryOrderedByChild in Swift with Firebase

Question

How can I get the value of the post where username = current user and isCompleted = false.

    override func viewWillAppear(animated: Bool) {
    // How can I make a query to get the post along with the current user and the isCompleted = false.
    let postRef = FIRDatabase.database().reference().child("posts").queryOrderedByChild("username").queryEqualToValue(FIRAuth.auth()!.currentUser!.displayName!)
    // If I write the query like below if it will through error
    // let postRef = FIRDatabase.database().reference().child("posts").queryOrderedByChild("username").queryEqualToValue(FIRAuth.auth()!.currentUser!.displayName!).queryOrderedByChild("isCompleted").queryEqualToValue(false)


    postRef.observeEventType(.Value, withBlock: { (snapshot) in



        var newPosts = [TodoItemDatabase]()
        for post in snapshot.children{



            let post = TodoItemDatabase(snapshot: post as! FIRDataSnapshot)
            newPosts.insert(post, atIndex: 0)

        }
        toDoList = newPosts

        dispatch_async(dispatch_get_main_queue(), {
            self.toDoListTable.reloadData()
        })
    }) { (error) in
        print(error.localizedDescription)
    }

}

Below is the data structure for the post

You can only have a single `orderBy...()` call in a Firebase query. For a potential workaround, see http://stackoverflow.com/questions/26700924/query-based-on-multiple-where-clauses-in-firebase — Frank van Puffelen, Sep 19 '16 at 14:21
@Dravidian: I want to retrieve with the specific username, and get all the post with "isCompleted" is false. How can I do it? — Đoàn Thanh An, Sep 19 '16 at 15:37

How to make a query to get multiple queryOrderedByChild in Swift with Firebase

0 Answers0