firebase get parent key by child value without child key

Question

i have the following structure:

how i can get all parent key where child value contain 4YCpSJIECJaMEp5poIGL4rIFnbs1

Firebase Database queries can only search across level of child nodes. Since your JSON structure contains two unknown levels, you can't query for a value. See https://stackoverflow.com/questions/27207059/firebase-query-double-nested — Frank van Puffelen, Aug 14 '19 at 14:19

score 2 · Answer 1 · answered Aug 14 '19 at 13:44

2

You can't get only a parent key with Firebase's queries. If you get parent's key you'll retrieve childs too. What you can do is first query on your key filter and then do the rest on front side. Try the following:

firebase.database().ref("roomUsers").orderByValue().equalsTo(key).once("value").then(snap => {
   const keys = [];
   snap.forEach(s => {
      keys.push(s.key);
   });
});

answered Aug 14 '19 at 13:44

Emeric

6,315
2
41
54

What is equalsto(key)? Where is key defined? – FabricioG Dec 29 '19 at 06:57
`key` is the parent's key you want to retrieve. – Emeric Jan 01 '20 at 16:29

firebase get parent key by child value without child key

1 Answers1