Query on multiple values in Firebase, similar to IN() SQL functionality

Question

I have an array that looks like this:

validZipCodes = [
  "84606",
  "84605",
  "84601"
]

I'm querying some data like this:

var Jobs = firebase.child('Jobs');

I tried this:

var Jobs = firebase.child('Jobs').orderByChild('ZipCode').equalTo($scope.validZipCodes);

But it returned an error that it was an invalid data-type, is there anyway to say something like:

var Jobs = firebase.child('Jobs').orderByChild('ZipCode').inArray($scope.validZipCodes);

Or something like that.

Note that this is an array comparison & not querying text in an object.

Jordash · Accepted Answer · 2015-05-09 00:06:30Z

4

Here is how I eventually did it:

With the foreach command you can easily manipulate data and then push it into an array to re-create a collection of data however you need it.

$scope.validZipCodes = [];
$scope.validContractorJobs = [];

var Jobs = firebase.child('Jobs');

contractorJobs.on('value', function(snap) {
            snap.forEach(function(job) {
                angular.forEach($scope.validZipCodes, function(value, key) {
                    if(job.val().ZipCode == value) {
                        $scope.validContractorJobs.push(job.val());
                    }
                });
            });
        });

answered May 9, 2015 at 0:06

Jordash

3,1238 gold badges46 silver badges80 bronze badges

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

Comments

Frank van Puffelen · Accepted Answer · 2015-05-08 21:57:22Z

1

The Firebase .equalTo() documentation states that the value argument should be one of the following types: String, Number, Null, or Boolean.

You are getting an invalid data-type error because you are not passing one of these types.
There is no method like .inArray() (i.e. querying for equalTo multiple values).

You can review all of the Firebase Query Methods in the Query documentation, which also suggests:

Read our documentation on ordering and querying data for more information and examples.

edited May 8, 2015 at 21:57

Frank van Puffelen

603k85 gold badges895 silver badges869 bronze badges

answered May 8, 2015 at 21:23

sbolel

3,52230 silver badges45 bronze badges

Collectives™ on Stack Overflow

Query on multiple values in Firebase, similar to IN() SQL functionality

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related