0

Is there any way to select specific properties from firebase Realtime Database? I know there is a way to retrieve selected properties from firestore but how can get via Realtime database using Node.js enter image description here

I want only Notes from everyone nothing else.

Suppose i just want to select Notes from Allergy here is my sample code which i tried but not successes...

admin.database().ref(`vitals/Allergy`).select('Notes').then(result => {//here is my result.....})

But it shows me that select is not a function.......

mk Mughal
  • 286
  • 4
  • 16

2 Answers2

1

Realtime Database doesn't support "projections" like this (neither does Cloud Firestore). If you are going to query across multiple child nodes, you are going to get each entire child node that matches the query. Even if you want just one property of each child, you can't avoid the cost of downloading the entire child.

If your app is very sensitive to performance on these types of queries, consider duplicating the data such that there is another branch of your database that contains only the "Notes" property, and query that branch alone. This duplication is common in NoSQL type databases, and is call the "fan out" technique.

Doug Stevenson
  • 297,357
  • 32
  • 422
  • 441
0

If you want to save download band then i can't help you further, otherelse:

let ArrayOfAllDownloadedNotes = [];
firebase.database().ref('yourRootFolders/vitals/Allergy').once((snapshot)=>{
  ArrayOfAllDownloadedNotes = [...ArrayOfAllDownloadedNotes, snapshot.val().Notes];
});

//Reapeat the firebase formula for every child you want retrieve the Notes from
//You may also use forEach((item)=>{}) function for each folder you want to retrieve the //notes from if you want

console.log(My Array of Notes:',ArrayOfAllDownloadedNotes );
Naruto Uzumaki
  • 442
  • 4
  • 7