How to query a JSON object

Question

In my AngularJS web app, How can I query a JSON object ?

For example in the below JSON object how can I find the value of reportTypeLabel where reportTypeId=3

JSON:

[  
   {  
      reportTypeId:5,
      reportTypeCode:"FINREP",
      reportTypeLabel:"Financial Reporting"
   },
   {  
      reportTypeId:9000002,
      reportTypeCode:"REM HE",
      reportTypeLabel:"High Earners"
   },
   {  
      reportTypeId:3,
      reportTypeCode:"COREP LE",
      reportTypeLabel:"Large Exposures - COREP"
   }
]

Related question: [Is there a query language for JSON?](https://stackoverflow.com/q/777455/195835) — Simon East, Jun 14 '21 at 09:10

score 3 · Answer 1 · answered Jan 19 '16 at 17:37

You can require $filter service and do

var elements = $filter('filter')(arrayOfObjects,{reportTypeId: 3});

elements will be an array of all the elements with that 'reportTypeId' i would recommend reading about angular filters and https://docs.angularjs.org/api/ng/service/$filter

score 1 · Accepted Answer · answered Jan 19 '16 at 17:37

If you're going to use data manipulation extensively, I'd highly recommend using a JS library, like underscore or lodash.

For example, using underscore:

// assuming your object is called data

var result = _.findWhere(data, {
    reportTypeId: 3
}).reportTypeLabel;
// result === 'Large Exposures - COREP'

score 1 · Answer 3 · edited Jan 19 '16 at 17:49

1

You could do this

<div ng-repeat="report in reports | filter:{reportTypeId:'3'}">
    {{report.reportTypeCode}}
</div>

Working Fiddle

edited Jan 19 '16 at 17:49

miensol

39,733
7
116
112

answered Jan 19 '16 at 17:38

Sajeetharan

216,225
63
350
396

Many thanks. Would there be any performance issue if the volume of data is very huge ? when compared with the below underscore approach. – Jay Jan 20 '16 at 15:33

miensol · Answer 4 · 2016-01-19T20:05:43.060

You can use regular filter function on array:

var items = [
  {reportTypeId:5, reportTypeCode:"FINREP"},
  {reportTypeId:9000002, reportTypeCode:"REM HE"}
];
var onlyMatching = items.filter(function(item){ return item.reportTypeId == 3; });

Or an angular filter in html

<div ng-repeat="item in items | filter: {reportTypeId: '3'}">{{item. reportTypeLabel}}</div>

Or an angular filter through $filter service

module.controller('ItemsCtrl', function($filter){
  $scope.filtered = $filter('filter')($scope.items,{ reportTypeId: '3' });
});

How to query a JSON object

4 Answers4

Linked