Query in Firebase realtime database

Question

What will be the Indexing and query for this in Firebase real-time Database?

Answer 1

This would be a way to sort and query on that params:

var ref = firebase
  .database()
  .ref("indraday/2021-08-29")
  .orderByChild("AAMRANET/cp")
  .startAt("0.00");

ref.once("value", (snap) => {
  snap.forEach((childSnap) => {
    var childKey = childSnap.key;
    var childData = childSnap.val();
    console.log(childData);
  });
});

Do consider that you save the value as String and not as number. That means it will be sorted as if it is a String and not a number.