How to do filter on nested array of object in more than two level

Question

I have a nested array of objects, I'm trying to filter the given array of objects using a property from the third level of its array property value. For example, from the below array I like to filter the entire array using the property "state" = "NY".

organisation = [
   {
      "dept_id":1,
      "dept":{
         "name":"finance",
         "employees":[
            {
               "emp_id":1,
               "name":"John",
               "address":[
                  {
                     "country":"US",
                     "state":"NC"
                  }
               ]
            }
         ]
      }
   },
   {
      "dept_id":2,
      "dept":{
         "name":"marketing",
         "employees":[
            {
               "emp_id":2,
               "name":"David",
               "address":[
                  {
                     "country":"US",
                     "state":"NY"
                  }
               ]
            }
         ]
      }
   },
   {
      "dept_id":3,
      "dept":{
         "name":"sales",
         "employees":[
            {
               "emp_id":3,
               "name":"Robert",
               "address":[
                  {
                     "country":"US",
                     "state":"NC"
                  }
               ]
            }
         ]
      }
   }
]

As a result of using the filter "state":"NY" my expected answer is

organisation = [
   {
      "dept_id":2,
      "dept":{
         "name":"marketing",
         "employees":[
            {
               "emp_id":2,
               "name":"David",
               "address":[
                  {
                     "country":"US",
                     "state":"NY"
                  }
               ]
            }
         ]
      }
   }
]

How can I use filter method using javascript to get this expected result.

organisation.filter(o => o.dept.employees.some(e => e.address.some(a => a.state === 'NY'))) — abhishekkannojia
– abhishekkannojia, Commented Aug 4, 2021 at 7:45
Thanks abhishekkannojia it is working .. if you can add this as an answer that will be great for reference .. once again thanks — Lalas M
– Lalas M, Commented Aug 4, 2021 at 7:53

Sajeeb Ahamed · Accepted Answer · 2021-08-04 07:48:21Z

3

You can use Array.prototype.filter, Array.prototype.some, and Array.prototype.find functions for achieving your required outcome. Try this-

const organisation=[{dept_id:1,dept:{name:"finance",employees:[{emp_id:1,name:"John",address:[{country:"US",state:"NC"}]}]}},{dept_id:2,dept:{name:"marketing",employees:[{emp_id:2,name:"David",address:[{country:"US",state:"NY"}]}]}},{dept_id:3,dept:{name:"sales",employees:[{emp_id:3,name:"Robert",address:[{country:"US",state:"NC"}]}]}}];

const filter = "NY";
const res = organisation.filter(
  item => item.dept.employees.some(
    employee => employee.address.find(address => address.state === filter)
  )
);

console.log(res);

Here, I've applied the filter on the organization array, then check if any employee inside the employees array has the address with the state value "NY".

answered Aug 4, 2021 at 7:48

Sajeeb Ahamed

6,4482 gold badges23 silver badges36 bronze badges

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

1 Comment

Lalas M Over a year ago

Thanks Sajeeb i will test this and update here

abhishekkannojia · Accepted Answer · 2021-08-04 08:04:09Z

You can use Array.prototype.filter with combination of Array.prototype.some to filter out the results you want.

const organisation=[{dept_id:1,dept:{name:"finance",employees:[{emp_id:1,name:"John",address:[{country:"US",state:"NC"}]}]}},{dept_id:2,dept:{name:"marketing",employees:[{emp_id:2,name:"David",address:[{country:"US",state:"NY"}]}]}},{dept_id:3,dept:{name:"sales",employees:[{emp_id:3,name:"Robert",address:[{country:"US",state:"NC"}]}]}}];
    
    const result = organisation.filter(
      item => item.dept.employees.some(
        employee => employee.address.some(address => address.state === 'NY')  // Filter condition
      )
    );
    
    console.log(result);

Basically this filters the organization array where some empoloyee has some address with state value 'NY'.

Rinshan Kolayil · Accepted Answer · 2021-08-04 08:24:45Z

1

const organisation=[{dept_id:1,dept:{name:"finance",employees:[{emp_id:1,name:"John",address:[{country:"US",state:"NC"}]}]}},{dept_id:2,dept:{name:"marketing",employees:[{emp_id:2,name:"David",address:[{country:"US",state:"NY"}]}]}},{dept_id:3,dept:{name:"sales",employees:[{emp_id:3,name:"Robert",address:[{country:"US",state:"NC"}]}]}}];

const filter = "NY";
const res = organisation.filter(item => item.dept.employees.find(add => JSON.stringify(add.address).includes('"state":"' + filter + '"')));

console.log(res);

answered Aug 4, 2021 at 8:24

Rinshan Kolayil

1,1491 gold badge10 silver badges16 bronze badges

Comments

S_C · Accepted Answer · 2021-08-04 07:54:40Z

you can use filter only if you want.

filtered = organisation.filter(el => el.dept.employees.filter(el => el.address.filter(el => el.state == 'NY').length > 0 ).length > 0);

organisation = [
   {
      "dept_id":1,
      "dept":{
         "name":"finance",
         "employees":[
            {
               "emp_id":1,
               "name":"John",
               "address":[
                  {
                     "country":"US",
                     "state":"NC"
                  }
               ]
            }
         ]
      }
   },
   {
      "dept_id":2,
      "dept":{
         "name":"marketing",
         "employees":[
            {
               "emp_id":2,
               "name":"David",
               "address":[
                  {
                     "country":"US",
                     "state":"NY"
                  }
               ]
            }
         ]
      }
   },
   {
      "dept_id":3,
      "dept":{
         "name":"sales",
         "employees":[
            {
               "emp_id":3,
               "name":"Robert",
               "address":[
                  {
                     "country":"US",
                     "state":"NC"
                  }
               ]
            }
         ]
      }
   }
]


filtered = organisation.filter(el => el.dept.employees.filter(el => el.address.filter(el => el.state == 'NY').length > 0 ).length > 0);

console.log(filtered);

MOHD SHAHZAIB · Accepted Answer · 2021-08-04 08:24:46Z

0

I filtered it like this. Try this

    const filteredOrg = [];
    
    organisation.forEach((item) => {
       item.dept.employees.forEach((employe) => {
        employe.address.forEach((address) => {
          if (address.state === "NY") {
            filteredOrg.push(item);
          }
        });
      });

});

I hope it will work for you too.

Happy coding!

answered Aug 4, 2021 at 8:24

MOHD SHAHZAIB

5503 silver badges12 bronze badges

Collectives™ on Stack Overflow

How to do filter on nested array of object in more than two level

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related