How to filter array based on id in angularJS

Question

i have multiple data for one id , i want filter my data like this

$scope.mpArray =[
{ Id: 1, Name: Madhu, Address: Upal },
{ Id: 1, Name: Chandu, Address: Upal },
{ Id: 2, Name: Srinu, Address: Kphb },
{ Id: 2, Name: Vijay, Address: kphb },
{ Id: 3, Name: Ajay, Address: Banglore },
{ Id: 3, Name: Narsi, Address: Banglore },
{ Id: 3, Name: Peter, Address: Banglore },
];

i want to filter my array like this

var FilterArray = [
{ Id: 1,Madhu, Chandu},
{ Id: 2, Srinu, Vijay},
{ Id: 3, Ajay, Narsi, Peter},
];

Hope this will help you. https://stackoverflow.com/questions/14800862/how-can-i-group-data-with-an-angular-filter][1] — A_D, Jul 04 '17 at 10:08
@Srinu can you please comment if it worked for you? And if yes, i would request you to mark it green. — Ankit Agarwal, Jul 04 '17 at 10:13
@Srinu try my answer . Surely, it will give you the result in exact form in which you want. — alfishan aqeel, Jul 04 '17 at 11:13
Possible duplicate of [How can I group data with an Angular filter?](https://stackoverflow.com/questions/14800862/how-can-i-group-data-with-an-angular-filter) — Veera, Jul 04 '17 at 11:32

score 0 · Accepted Answer · answered Jul 04 '17 at 10:06

At first you need to change your FilterArray to

[
  {
    "Id": 1,
    "Name": [
      "Madhu",
      "Chandu"
    ]
  },
  {
    "Id": 2,
    "Name": [
      "Srinu",
      "Vijay"
    ]
  },
  {
    "Id": 3,
    "Name": [
      "Ajay",
      "Narsi",
      "Peter"
    ]
  }
]

Notice that name is an array. The FilterArray of your question

var FilterArray = [
{ Id: 1,Madhu, Chandu},
{ Id: 2, Srinu, Vijay},
{ Id: 3, Ajay, Narsi, Peter},
];

Do not contain a valid JSON object inside the array so you need to change the structure to the one where add a new key Name in the JSON object of FilterArray as like the first structure above. Then the below code works great.

$(document).ready(function(){
var myArray =[
{ Id: 1, Name: "Madhu", Address: "Upal" },
{ Id: 1, Name: "Chandu", Address: "Upal" },
{ Id: 2, Name: "Srinu", Address: "Kphb" },
{ Id: 2, Name: "Vijay", Address: "kphb" },
{ Id: 3, Name: "Ajay", Address: "Banglore" },
{ Id: 3, Name: "Narsi", Address: "Banglore" },
{ Id: 3, Name: "Peter", Address: "Banglore" },
];
var FilterArray = [];
var matched;
  for(var i=0;i<myArray.length; i++){
     matched = false;
     var myArrayId = myArray[i].Id;
       for(var j=0; j<FilterArray.length; j++){
         var FilterArrayId = FilterArray[j].Id;
          if(myArrayId === FilterArrayId){
              matched = true;
              FilterArray[j].Name.push(myArray[i].Name);
              // no need to loop further
              break;
          }
       }
       if(!matched){
           var obj = {
              'Id' : myArrayId,
              'Name' : [myArray[i].Name],
           }
           FilterArray.push(obj);
       }
  }
 console.log(FilterArray);
});

<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>

score 0 · Answer 2 · answered Jul 04 '17 at 10:07

try this

var mpArray =[
{ Id: 1, Name: 'Madhu', Address: 'Upal' },
{ Id: 1, Name: 'Chandu', Address: 'Upal' },
{ Id: 2, Name: 'Srinu', Address: 'Kphb' },
{ Id: 2, Name: 'Vijay', Address: 'kphb' },
{ Id: 3, Name: 'Ajay', Address: 'Banglore' },
{ Id: 3, Name: 'Narsi', Address: 'Banglore' },
{ Id: 3, Name: 'Peter', Address: 'Banglore' },
];

var filterObject = {};

mpArray.forEach(function (item) {
    if (!filterObject[item.Id]) {
        filterObject[item.Id] = [];
    }
    
    filterObject[item.Id].push(item.Name);
});

console.log(filterObject);

pls analys in what form he wants to data after filtering. – alfishan aqeel Jul 04 '17 at 11:09 — alfishan aqeel, Jul 04 '17 at 11:09

alfishan aqeel · Answer 3 · 2017-07-04T10:56:49.147

$scope.mpArray =[
                    { Id: 1, Name: 'Madhu', Address: 'Upal' },
                    { Id: 1, Name: 'Chandu', Address: 'Upal' },
                    { Id: 2, Name: 'Srinu', Address: 'Kphb' },
                    { Id: 2, Name: 'Vijay', Address: 'kphb' },
                    { Id: 3, Name: 'Ajay', Address: 'Banglore' },
                    { Id: 3, Name: 'Narsi', Address: 'Banglore' },
                    { Id: 3, Name: 'Peter', Address: 'Banglore' },
                    ];
                    var FilterArray = [];
                    var FilteredArrayIds=[];
                    $scope.mpArray.forEach(
                                            function(detailObj) {
                                                if(FilteredArrayIds.indexOf(detailObj.Id)==-1)
                                                 return FilteredArrayIds.push(detailObj.Id);
                                        });
                    for(var i=0; i<FilteredArrayIds.length;i++)
                    {
                          var result = $scope.mpArray.filter(function( obj ) {
                              return obj.Id == FilteredArrayIds[i];
                          });
                          var rsltNames = result.map(function(obj){
                            return obj.Name;
                          })
                          var filteredObj ={
                            id:FilteredArrayIds[i]+',' +rsltNames.join()
                          }
                          FilterArray.push(filteredObj);
                    }
                    console.log(filteredObj)

Instead of pasting a whole code, explain what it does. – Mistalis Jul 12 '17 at 15:09 — Mistalis, Jul 12 '17 at 15:09

How to filter array based on id in angularJS

3 Answers3