iOS Firebase get data where value equals to something

user_4862280 0
Viewed 1387

How can I get data in swift3 from firebase where the value equals something.

In MySQL that would be "SELECT * FROM users WHERE type = 'brown'"; how can I write that where part in Firebase?

I have this DB

enter image description here

And I want to get all the data from it where month == currentMonth (I have a currentMonth variable)

firebase-realtime-database firebase swift ios
2 Answers

You can Query like this:

let ref = Database.database().reference()
ref.child("Budget")
    .queryOrdered(byChild: "Month")
    .queryEqual(toValue: "November")
    .observe(.value, with: { (snapshot: DataSnapshot) in

        var array:[Budget] = []

        for budgetChild in snapshot.children {
            let budgetSnapshot = budgetChild as! DataSnapshot
            let budgetDictionary = budgetSnapshot.value as! [String:String]

            let budget: Budget = Budget()
            budget.description_ = budgetDictionary["Description"]
            budget.month = budgetDictionary["Month"]
            budget.type = budgetDictionary["Type"]
            budget.value = budgetDictionary["Value"]

            array.append(budget)
        }
    })
user_48505610

As far as I'm aware firebase realtime database doesn't have support for querying like this. Instead you need to call down the whole ref 'budget' then filter it locally in your app.

FireStore apparently has better query support although its in Beta.

user_26099390
Related