Filter JSON array by values included in two arrays (javascript)

Question

I'm writing a JSON array filter function based on multiple criteria.
The filter depends on two arrays: 1. The first one contains values that have to be part of searched JSON, and 2. the second contains values that are optional.

I mean to return only the array entries that contain ALL the values from the obligatory array and at least one item from the optional array.

Here's my attempt:

const searchKeys = ['varWord', 'varTrans', 'varSpec'],
  obligatory = ['trip', 'pret'],
  optional = ['greet', 'lco', 'toto', 'bene'];

function filterByUpdate(obligatory, optional, file) {
  return _.filter(file, item => {
    return _.some(optional, opt => {
      return _.every(obligatory, oblg => {
        return _.some(item, value => {
          return _.some(searchKeys, n => item[n].toLowerCase().includes(oblg.toLowerCase())) &&
            searchKeys.some(n => item[n].toLowerCase().includes(opt.toLowerCase()))
        })
      });
    });
  });
}

The code above should only preserve the first entry from the following data array:

[{
  "varSpec": "trip",
  "varTrans": "pret",
  "varWord": "greet",
  "stringPol": "group",
  "stringDva": "groupGend",
  "stringGit": "/tax",
}, {
  "varSpec": "trip",
  "varTrans": "pret",
  "varWord": "friend",
  "stringPol": "N",
  "stringDva": "N",
  "stringGit": "N",
}, {
  "varSpec": "group1",
  "varTrans": "grp1",
  "varWord": "ageGroup1",
  "stringPol": "N",
  "stringDva": "N",
  "stringGit": "N",
}]

searchKeys is an array of JSON Keys, that contain searched values. — user2188452
– user2188452, Commented Sep 23, 2018 at 16:27
Seems to be working fine. What output you want. It is returning varSpec: "trip" varTrans: "pret" varWord: "greet" stringPol: "group" stringDva: "groupGend" stringGit: "/tax" — Shubham Gupta
– Shubham Gupta, Commented Sep 23, 2018 at 16:28
ooh yes you are right! thank you for your time, my problem was in different part of my code. — user2188452
– user2188452, Commented Sep 23, 2018 at 17:57

ccjmne · Accepted Answer · 2018-09-23 17:34:12Z

2

You could go for this pretty simple algorithm:

const { flow, intersection, pick } = require('lodash/fp');

data.filter(
  flow(
    pick(searchKeys),
    entry => intersection(Object.values(entry)),
    intersectWith => intersectWith(obligatory).length === obligatory.length &&
                     intersectWith(optional).length >= 1
  )
);

It basically boils down to checking for the intersection between, on the first hand, the relevant values (identified by searchKeys) in each entry of your dataset (data), and on the other:

the obligatory array of values: the intersection must be of obligatory.length length.
i.e.: it contains all the items from the obligatory collection
the optional array of values: the intersection array's length must be >= 1.
i.e.: it contains at least 1 item from the optional collection

Here's a link to a working repl.

edited Sep 23, 2018 at 17:34

answered Sep 23, 2018 at 17:28

ccjmne

9,6213 gold badges52 silver badges68 bronze badges

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

1 Comment

user2188452 Over a year ago

thank you man, really appreciate your help and provided example. Gonna try it.

Collectives™ on Stack Overflow

Filter JSON array by values included in two arrays (javascript)

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related