Filter array of objects by key and value contained in another object

Question

There is a way to filter (or query) an array structured like this:

[   {
            'xml:id': 'Name1',
            sex: {
                '$t': 'M'
            },
            occupation: {
                n: 1,
                '$t': 'bank'
            }
        },
        {
            'xml:id': 'Name2',
            sex: {
                '$t': 'M'
            },
            occupation: {
                n: 1,
                '$t': 'writer'
            }
        }, {
            'xml:id': 'Name3',
            sex: {
                '$t': 'F'
            },
            occupation: {
                n: 1,
                '$t': 'bank'
            }
        }, {
            'xml:id': 'Name4',
            sex: {
                '$t': 'M'
            },
            occupation: {
                n: 1,
                '$t': 'writer'
            },
        }, {
            'xml:id': 'Name5',
            sex: {
                '$t': 'M'
            },
            occupation: {
                n: 1,
                '$t': 'writer'
            }
        }
    ]

whit a query of this type:

const pers_query: Query = {
  type: 'person',
  args: [
    {
      key: 'occupation',
      value: 'bank',
    },
    {
      key: 'sex',
      value: 'f',
    },
  ],
};

What I want is to filter the data with multiple keys and values, in this specific case I want to filter the data for all the occurrences of object that contains the key sex with value f AND the key occupation with value bank

the result should be something like this:

[
   {
        'xml:id': 'Name3',
        sex: {
            '$t': 'F'
        },
        occupation: {
            n: 1,
            '$t': 'bank'
        }
    }
]

It's invalid. Use jsonlint.com to check. If the exact format doesn't matter, then you probably don't mean JSON, but instead a JS Object. — evolutionxbox
– evolutionxbox, Commented Jul 14, 2021 at 9:11
yes, I'm so sorry I wrote JSON data because it's an extraction of an array of objects inside a JSON structure. My bad. — RootAtKali
– RootAtKali, Commented Jul 14, 2021 at 9:24

pilchard · Accepted Answer · 2021-07-14 09:13:07Z

2

You can use a combination of Array.prototype.filter() and Array.prototype.each

const input = [{    'xml:id': 'Name1',    sex: {      '$t': 'M'    },    occupation: {      n: 1,      '$t': 'bank'    }  },  {    'xml:id': 'Name2',    sex: {      '$t': 'M'    },    occupation: {      n: 1,      '$t': 'writer'    }  }, {    'xml:id': 'Name3',    sex: {      '$t': 'F'    },    occupation: {      n: 1,      '$t': 'bank'    }  }, {    'xml:id': 'Name4',    sex: {      '$t': 'M'    },    occupation: {      n: 1,      '$t': 'writer'    },  }, {    'xml:id': 'Name5',    sex: {      '$t': 'M'    },    occupation: {      n: 1,      '$t': 'writer'    }  }]
const pers_query = {
  type: 'person',
  args: [{
      key: 'occupation',
      value: 'bank',
    },
    {
      key: 'sex',
      value: 'f',
    },
  ],
};

const output = input.filter(person => {
  return pers_query.args.every(condition => {
    return person[condition.key]['$t'].toLowerCase() === condition.value.toLowerCase();
  });
});

console.log(output);

edited Jul 14, 2021 at 9:13

pilchard

13.1k5 gold badges14 silver badges27 bronze badges

answered Jul 14, 2021 at 9:11

Sarah Groß

10.9k4 gold badges30 silver badges53 bronze badges

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

2 Comments

RootAtKali Over a year ago

Thank you so much, this is what I looking for.

Sarah Groß Over a year ago

fee.l free to mark it as accepted and/or upvote as you see fit

majdsalloum · Accepted Answer · 2021-07-14 09:11:04Z

0

function filterData(data,query,caseSensitive=false) {
    let filteredData = data;
    // no use for type since it's  not in data
    query.args.forEach(arg => filteredData = filteredData.filter(item => caseSensitive ? item[arg.key]['$t'] === arg.value : item[arg.key]['$t'].toLowerCase() === arg.value.toLowerCase())); // you can use .lowe

    return filteredData;
}

This is one way to do it, note that we assign filteredData with data at beginning since where applying filter and that won't cause any change to the original array.

answered Jul 14, 2021 at 9:11

majdsalloum

5161 gold badge4 silver badges17 bronze badges

Collectives™ on Stack Overflow

Filter array of objects by key and value contained in another object

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related