在 Firebase 中查询多个值，类似于 IN() SQL 功能 [英] Query on multiple values in Firebase, similar to IN() SQL functionality

问题描述

我有一个看起来像这样的数组:

I have an array that looks like this:

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

我正在查询一些这样的数据:

I'm querying some data like this:

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

我试过了:

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);

或者类似的东西.

注意这是一个数组比较&不查询对象中的文本.

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

推荐答案

这是我最终做到的:

使用 foreach 命令，您可以轻松操作数据，然后将其推入数组以重新创建您需要的数据集合.

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());
                    }
                });
            });
        });

这篇关于在 Firebase 中查询多个值，类似于 IN() SQL 功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！