过滤JSON文件中的数据 [英] filter data in a JSON file
本文介绍了过滤JSON文件中的数据的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我目前正在使用JSON文件开发一个小型应用程序.我的数据有问题.我必须过滤我的数据.例如,我想要某个用户ID的所有数据,但是我不知道该怎么做. 这是我的JSON文件的示例:
I'm currently developing a small application using a JSON file. I have a problem with my data. I must filter my data. For example, I want all the data for a certain User Id but I don't know how doing that. Here is an example of my JSON file:
[{
"ConsoPhot_Id": "7924",
"idLotImport": 166,
"Date_Id": 20160601,
"Orga_Id": "86094",
"NbTache": 35,
"NbCopie": 143,
"NbCopieBW": 56,
"NbCopieCouleur": 87,
"MtTotal": 3.53
},
{
"ConsoPhot_Id": "7925",
"idLotImport": 166,
"Date_Id": 20160601,
"Orga_Id": "86537",
"NbTache": 291,
"NbCopie": 969,
"NbCopieBW": 622,
"NbCopieCouleur": 347,
"MtTotal": 15.61
},
{
"ConsoPhot_Id": "7926",
"idLotImport": 166,
"Date_Id": 20160601,
"Orga_Id": "86386",
"NbTache": 7,
"NbCopie": 32,
"NbCopieBW": 31,
"NbCopieCouleur": 1,
"MtTotal": 0.16
},
{
"ConsoPhot_Id": "7927",
"idLotImport": 166,
"Date_Id": 20160601,
"Orga_Id": "86084",
"NbTache": 2,
"NbCopie": 3,
"NbCopieBW": 3,
"NbCopieCouleur": 0,
"MtTotal": 0.01
},
{
"ConsoPhot_Id": "7928",
"idLotImport": 166,
"Date_Id": 20160701,
"Orga_Id": "86094",
"NbTache": 33,
"NbCopie": 68,
"NbCopieBW": 31,
"NbCopieCouleur": 37,
"MtTotal": 1.53
},
例如,我要Orga_Id
:"86094
" JSON文件中的所有数据.我唯一能做的就是举例说明所有数据:
For example, I want for Orga_Id
: "86094
" all the data in the JSON file. The only thing that i can do is taking all the data with this for example:
d3.json("Data.json", function(error, data) {
var NbCopie = data.map(function(d) {
return d.NbCopie;
});
推荐答案
您可以使用Array#filter()
以下代码在ES6
const data =[{"ConsoPhot_Id":"7924","idLotImport":166,"Date_Id":20160601,"Orga_Id":"86094","NbTache":35,"NbCopie":143,"NbCopieBW":56,"NbCopieCouleur":87,"MtTotal":3.53},{"ConsoPhot_Id":"7925","idLotImport":166,"Date_Id":20160601,"Orga_Id":"86537","NbTache":291,"NbCopie":969,"NbCopieBW":622,"NbCopieCouleur":347,"MtTotal":15.61},{"ConsoPhot_Id":"7926","idLotImport":166,"Date_Id":20160601,"Orga_Id":"86386","NbTache":7,"NbCopie":32,"NbCopieBW":31,"NbCopieCouleur":1,"MtTotal":0.16},{"ConsoPhot_Id":"7927","idLotImport":166,"Date_Id":20160601,"Orga_Id":"86084","NbTache":2,"NbCopie":3,"NbCopieBW":3,"NbCopieCouleur":0,"MtTotal":0.01},{"ConsoPhot_Id":"7928","idLotImport":166,"Date_Id":20160701,"Orga_Id":"86094","NbTache":33,"NbCopie":68,"NbCopieBW":31,"NbCopieCouleur":37,"MtTotal":1.53}];
const key = "Orga_Id";
const value= "86094";
const result = data.filter(d=>d[key]==value);
console.log(result);
这篇关于过滤JSON文件中的数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文