angularfirebase2 query where key equals value

Question

I'm giving shot at firebase, converting an existing database to firebase. How do i select a list where the value of a key equals a specific value?

getAllUsers() {
    return this.fireBase.list(
        '/users',
        ref => ref
            .orderByChild('last_name')
            // active = true
    ).valueChanges();
}

Are you trying to order by last name and then filter for a specific value of active (I.e. true)? — Renaud Tarnec
– Renaud Tarnec, Commented Jan 18, 2019 at 18:25

Renaud Tarnec · Accepted Answer · 2019-01-18 20:00:55Z

1

With the Firebase Realtime Database you cannot use orderBy() on one field and then use equalTo() on another field. And you cannot use two different orderBy().

This is detailed/explained in the docs, here (angularfire2 ) and here ("standard" Javascript SDK).

However you could use a composed value like active_lastname with a query like the following one:

  var database = firebase.database();
  database
    .ref('users')
    .orderByChild('composedValue')
    .startAt('true_')
    .endAt('true_\uf8ff')
    .once('value', function(snapshot) {
      snapshot.forEach(function(childSnapshot) {
        var childKey = childSnapshot.key;
        var childData = childSnapshot.val();
        console.log(childKey);
        console.log(childData);
      });
    });

You composed values would be like:

true_Obama
true_Bush
false_Carter
....

So for angularFire2, based on your code it would be:

getAllUsers() {
    return this.fireBase.list(
        '/users',
        ref => ref
            .orderByChild('composedValue')
            .startAt('true')
            .endAt('true\uf8ff')
    ).valueChanges();
}

edited Jan 18, 2019 at 20:00

answered Jan 18, 2019 at 18:40

Renaud Tarnec

83.4k10 gold badges99 silver badges130 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Sandra Willford Over a year ago

thanks. i think it's more important for me to filter by the value, so i will handle the sorting by name on the client side.

Renaud Tarnec Over a year ago

Just note that the second part of my initial answer was wrong... You cannot reach your goal by using a composed values starting by the last_name. But you can achieve it with a composed value starting by the active value, see my updated answer.

Collectives™ on Stack Overflow

angularfirebase2 query where key equals value

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related