how to filter an array on condition like SQL IN clause using lodash?

Question

I am trying to filter data which are present in an array using lodash. I am trying to filter like SQL IN clause.

ex: - select * from Test where id IN (2,4,5,67);

JSON:

storedData = [
    {
        "id" : 1,
        "name" : "ABC"
    },
    {
        "id" : 2,
        "name" : "XYZ"
    },
    {
        "id" : 3,
        "name" : "BVX"
    },
    {
        "id" : 4,
        "name" : "OOO"
    }
]

Search criteria:

[2,4,5,67]

Required Output:

output = [
    {
        "id" : 2,
        "name" : "XYZ"
    },
    {
        "id" : 4,
        "name" : "OOO"
    }
]

Below is my code which i tried to implement

output = _.filter(storedData, (value) => {
    return value.id == 2 || value.id == 4 || value.id == 5 || value.id == 67
});

Could you please help me how to filter like IN clause ?

Nick Parsons · Accepted Answer · 2020-09-09 04:16:38Z

3

You can find the intersection between the two arrays using intersectionWith, which allows you to provide a callback and will keep all elements from the first array which the callback returns true for.

See example below:

const storedData = [ { "id" : 1, "name" : "ABC" }, { "id" : 2, "name" : "XYZ" }, { "id" : 3, "name" : "BVX" }, { "id" : 4, "name" : "OOO" } ];
const search = [2,4,5,67];

const res = _.intersectionWith(storedData, search, (o, n) => o.id === n); 
console.log(res);

<script src="https://cdnjs.cloudflare.com/ajax/libs/lodash.js/4.17.15/lodash.min.js"></script>

answered Sep 9, 2020 at 4:16

Nick Parsons

51.7k6 gold badges61 silver badges80 bronze badges

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

Comments

hgb123 · Accepted Answer · 2020-09-09 04:10:24Z

2

Use .includes

_.filter(storedData, (value) => _.includes(criteria, value.id))

const storedData = [
  {
    id: 1,
    name: "ABC",
  },
  {
    id: 2,
    name: "XYZ",
  },
  {
    id: 3,
    name: "BVX",
  },
  {
    id: 4,
    name: "OOO",
  },
]

const criteria = [2, 4, 5, 67]

const output = _.filter(storedData, (value) => _.includes(criteria, value.id))

console.log(output)

<script src="https://cdn.jsdelivr.net/npm/[email protected]/lodash.min.js"></script>

answered Sep 9, 2020 at 4:10

hgb123

14.9k3 gold badges24 silver badges43 bronze badges

Collectives™ on Stack Overflow

how to filter an array on condition like SQL IN clause using lodash?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related