在火力地堡多个值查询，类似于（）的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);

或者类似的东西。

Or something like that.

请注意，这是一个数组比较和;在对象中没有查询文本。

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

推荐答案

下面是如何我最终做到了：

Here is how I eventually did it:

通过在f​​oreach命令你可以轻松地处理数据，然后将其推到一个数组重新创建数据的集合，但是你需要它。

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

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