How can I query and filter Firebase Realtime Database [duplicate]

Question

I would like to get all persons from the database where first name and last name is given by user input.

So far this is my code:

admin.database().ref('persons').orderByChild('Firstname').equalTo(firstName).limitToLast(1).once("value").then(function(snapshot) {
}

This code works filtering only Firstname, but I cant find any way of adding another Where Clause for Last name. I tried to add another orderBy but it does not seem working. Does the Realtime Database has to be this hard to make a simple query?

Answer 1

The short answer: you can't. The long answer: use Google's new Firestore database or perform the filtering on the client manually. See this answer for other options.