Daniele Dolci
Daniele Dolci

Reputation: 884

Firebase, get property by email

I have this database on Firebase:

{
  "issues" : {
    "-L04771_EjrLlv5u1-GU" : {
      "issue" : "Test insert 1",
      "last_edit" : "d8QICgTG5xR20RBzAXfzfu8gLgw2",
      "owner" : "d8QICgTG5xR20RBzAXfzfu8gLgw2",
      "owner_email" : "[email protected]",
      "status" : 1,
      "url" : "http://www.example.com/example.html"
    },
    "-L047pIoqxkj4saaTYyQ" : {
      "issue" : "Test insert 2",
      "last_edit" : "d8QICgTG5xR20RBzAXfzfu8gLgw2",
      "owner" : "d8QICgTG5xR20RBzAXfzfu8gLgw2",
      "owner_email" : "[email protected]",
      "status" : 1,
      "url" : "http://www.example.com/example.html"
    }
  }
}

I have to extract only those who have owner_email "[email protected]".

Is possible?

Upvotes: 0

Views: 25

Answers (1)

Frede
Frede

Reputation: 701

You're probably looking for Firebase Queries and especially the equalTo-Query.

Your code would be something like this:

// Find all issues with owner_email = [email protected]
var ref = firebase.database().ref("issues");
ref.orderByChild("owner_email").equalTo("[email protected]").on("value", function(snapshot) {
   // Loops through the matching issues
   snapshot.forEach(function(child) { 
      console.log(child.key); 
   });
});

Upvotes: 2

Related Questions