How to filter array when object key value is in array

Question

I have an array model, as below:

records:[{
    "empid":1,
    "fname": "X",
    "lname": "Y"
},
{
    "empid":2,
    "fname": "A",
    "lname": "Y"
},
{
    "empid":3,
    "fname": "B",
    "lname": "Y"
},
{
    "empid":4,
    "fname": "C",
    "lname": "Y"
},
{
    "empid":5,
    "fname": "C",
    "lname": "Y"
}
]

Now I have an array of empid's [1,4,5].

So now, I need to filter the first array, which contains all the keys in my second.

Output:

records:[{
    "empid":1,
    "fname": "X",
    "lname": "Y"
},
{
    "empid":4,
    "fname": "C",
    "lname": "Y"
},
{
    "empid":5,
    "fname": "C",
    "lname": "Y"
}
]

I can do this using a forEach loop in angular, but as I have more than 100 records in my model object, I need a way to handle this in a much cleaner way.

I'm thinking of creating a custom filter, but what is your take on it? (If yes, please provide sample code to achieve this).

No, data is not sorted.. Aravindsamy's solution looks good.. Thank you guys for quick response.. — krsnaadi
– krsnaadi, Commented Mar 5, 2016 at 18:01
Almost duplicate of javascript - How to filter object array based on attributes? - Stack Overflow -- although in this case the condition is a little more complicated (with includes)'ll — user202729
– user202729, Commented Feb 16, 2021 at 10:11

Preactive · Accepted Answer · 2018-11-16 17:32:54Z

95

You can do it with Array.prototype.filter(),

var data = { records : [{ "empid": 1, "fname": "X", "lname": "Y" }, { "empid": 2, "fname": "A", "lname": "Y" }, { "empid": 3, "fname": "B", "lname": "Y" }, { "empid": 4, "fname": "C", "lname": "Y" }, { "empid": 5, "fname": "C", "lname": "Y" }] }
var empIds = [1,4,5]
var filteredArray = data.records.filter(function(itm){
  return empIds.indexOf(itm.empid) > -1;
});

filteredArray = { records : filteredArray };

If the callBack returns a true value, then the itm passed to that particular callBack will be filtered out. You can read more about it here.

edited Nov 16, 2018 at 17:32

Preactive

3101 silver badge13 bronze badges

answered Mar 5, 2016 at 17:53

Rajaprabhu Aravindasamy

67.2k17 gold badges107 silver badges133 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

krsnaadi Over a year ago

This is really simple and easy @Rajaprabhu,but any information related to performance while doing this on large data(about 500-1000) length array,

Rajaprabhu Aravindasamy Over a year ago

@KrishnaAditya It is very similar to for loop, internally data will be iterated by using for loops, But in an efficient way. This makes code more readable and maintainable.

andersoal Over a year ago

Maybe you can look at javascript - Filter array of objects with another array of objects - Stack Overflow for a different approach.

Tim Elsass · Accepted Answer · 2019-05-17 07:57:34Z

68

In 2019 using ES6:

const ids = [1, 4, 5],
  data = {
    records: [{
      "empid": 1,
      "fname": "X",
      "lname": "Y"
    }, {
      "empid": 2,
      "fname": "A",
      "lname": "Y"
    }, {
      "empid": 3,
      "fname": "B",
      "lname": "Y"
    }, {
      "empid": 4,
      "fname": "C",
      "lname": "Y"
    }, {
      "empid": 5,
      "fname": "C",
      "lname": "Y"
    }]
  };


data.records = data.records.filter( i => ids.includes( i.empid ) );

console.info( data );

answered May 17, 2019 at 7:57

Tim Elsass

1,0068 silver badges9 bronze badges

2 Comments

Andreas Over a year ago

Some words of explanation would increase the value of your answer immensely for JavaScript beginners. ;)

Tyler Over a year ago

@Andreas, He basically creates a temporary array (ids) that he wants to use as a filter criteria. Then he uses the filter function on the data.records array and says "remove all items that do not have an ID matching one of those in the temporary array", and reassigns this to the data.records array. The key functions here are Array.filter and Array.includes.

Nina Scholz · Accepted Answer · 2016-03-05 18:08:50Z

3

This is a fast solution with a temporary object.

var records = [{ "empid": 1, "fname": "X", "lname": "Y" }, { "empid": 2, "fname": "A", "lname": "Y" }, { "empid": 3, "fname": "B", "lname": "Y" }, { "empid": 4, "fname": "C", "lname": "Y" }, { "empid": 5, "fname": "C", "lname": "Y" }],
    empid = [1, 4, 5],
    object = {},
    result;

records.forEach(function (a) {
    object[a.empid] = a;
});

result = empid.map(function (a) {
    return object[a];
});
document.write('<pre>' + JSON.stringify(result, 0, 4) + '</pre>');

edited Mar 5, 2016 at 18:08

answered Mar 5, 2016 at 17:54

Nina Scholz

388k26 gold badges367 silver badges417 bronze badges

1 Comment

krsnaadi Over a year ago

Yeah this even looks good. More likely as hash key look up,I will check this one as well. Thanks @Nina

isvforall · Accepted Answer · 2016-03-05 18:15:09Z

2

You can use Array#filter function and additional array for storing sorted values;

var recordsSorted = []

ids.forEach(function(e) {
    recordsSorted.push(records.filter(function(o) {
        return o.empid === e;
    }));
});

console.log(recordsSorted);

Result:

[ [ { empid: 1, fname: 'X', lname: 'Y' } ],
  [ { empid: 4, fname: 'C', lname: 'Y' } ],
  [ { empid: 5, fname: 'C', lname: 'Y' } ] ]

answered Mar 5, 2016 at 18:15

isvforall

8,9166 gold badges39 silver badges52 bronze badges

Comments

me_astr · Accepted Answer · 2016-03-05 19:06:02Z

1

Fastest way (will take extra memory):

var empid=[1,4,5]
var records = [{ "empid": 1, "fname": "X", "lname": "Y" }, { "empid": 2, "fname": "A", "lname": "Y" }, { "empid": 3, "fname": "B", "lname": "Y" }, { "empid": 4, "fname": "C", "lname": "Y" }, { "empid": 5, "fname": "C", "lname": "Y" }] ;

var empIdObj={};

empid.forEach(function(element) {
empIdObj[element]=true;
});

var filteredArray=[];

records.forEach(function(element) {
if(empIdObj[element.empid])
    filteredArray.push(element)
});

answered Mar 5, 2016 at 19:06

me_astr

1,0421 gold badge15 silver badges23 bronze badges

Comments

black_pottery_beauty · Accepted Answer · 2021-02-16 14:25:39Z

Old way of doing it. Many might hate this way of doing but i still many time find this is still better in my perspective.

Input:

var records = [{
    "empid":1,
    "fname": "X",
    "lname": "Y"
},
{
    "empid":2,
    "fname": "A",
    "lname": "Y"
},
{
    "empid":3,
    "fname": "B",
    "lname": "Y"
},
{
    "empid":4,
    "fname": "C",
    "lname": "Y"
},
{
    "empid":5,
    "fname": "C",
    "lname": "Y"
}
]

var newArr = [1,4,5];

Code:

var newObj = [];
for(var a = 0 ; a < records.length ; a++){
 if(newArr.indexOf(records[a].empid) > -1){
  newObj.push(records[a]);
 }
}

The indexOf() method returns the first index at which a given element can be found in the array, or -1 if it is not present.

Reference - https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Array/indexOf

Output:

[{
    "empid": 1,
    "fname": "X",
    "lname": "Y"
}, {
    "empid": 4,
    "fname": "C",
    "lname": "Y"
}, {
    "empid": 5,
    "fname": "C",
    "lname": "Y"
}]

manjit singh · Accepted Answer · 2021-09-11 04:43:49Z

0

var records = [{
 "empid":1,
 "fname": "X",
 "lname": "Y"
},
{
 "empid":2,
 "fname": "A",
 "lname": "Y"
}

]


let search="A"
 
let values= Result.filter(item =>
     keys.some(key => 
         String(item[key]).toLowerCase().includes(search.toLowerCase()) 
     )
 );

multikey search in object Array eg.(empid,fname,lname)

edited Sep 11, 2021 at 4:43

answered Sep 10, 2021 at 10:44

manjit singh

191 silver badge4 bronze badges

2 Comments

Community Over a year ago

Please add further details to expand on your answer, such as working code or documentation citations.

Paulo Over a year ago

You could use the javascript/html/css snippet accessible with CTRL+M to make the code able to be run.

Peter van der Lely · Accepted Answer · 2019-11-01 16:54:41Z

-1

In case you have key value pairs in your input array, I used:

.filter(
          this.multi_items[0] != null && store.state.isSearchBox === false
            ? item =>
                _.map(this.multi_items, "value").includes(item["wijknaam"])
            : item => item["wijknaam"].includes("")
        );

where the input array is multi_items as: [{"text": "bla1", "value": "green"}, {"text": etc. etc.}]

_.map is a lodash function.

answered Nov 1, 2019 at 16:54

Peter van der Lely

1091 silver badge11 bronze badges

Collectives™ on Stack Overflow

How to filter array when object key value is in array

8 Answers 8

3 Comments

2 Comments

1 Comment

Comments

Comments

Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

3 Comments

2 Comments

1 Comment

Comments

Comments

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related