在 Firebase 中查询多个值,类似于 IN() SQL 功能 [英] Query on multiple values in Firebase, similar to IN() SQL functionality
本文介绍了在 Firebase 中查询多个值,类似于 IN() SQL 功能的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有一个看起来像这样的数组:
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屋!
查看全文