Filter JSON object array on multiple values or arguments javascript

Question

users = [
  {
    "username": "Alice",
    "firstName": "Alice-U",
    "lastName": "Wonderland"
  },
  {
    "username": "bob",
    "firstName": "Bob-u",
    "lastName": "Builder",
  },
  {
    "username": "charly",
    "firstName": "Charly-u",
    "lastName": "Brown",
  }
]

I want to be able to filter this array on multiple values like:

Search Criteria: { "username" : "Alice" } should return:

{
    "username": "Alice",
    "firstName": "Alice-U",
    "lastName": "Wonderland"
}

Similary for: { "username" : "charly", "firstName": "Charly-u" } should return :

{
    "username": "charly",
    "firstName": "Charly-u",
    "lastName": "Brown",
}

with exact string matching using javaScript or jQuery.

Amadan · Accepted Answer · 2018-09-25 02:33:39Z

5

You can employ .every to check that each of the criteria keys matches:

function filterBy(list, criteria) {
  return list.filter(candidate =>
    Object.keys(criteria).every(key =>
      candidate[key] == criteria[key]
    )
  );
}

let users = [
  { "username": "Alice", "firstName": "Alice-U", "lastName": "Wonderland" },
  { "username": "bob", "firstName": "Bob-u", "lastName": "Builder" },
  { "username": "charly", "firstName": "Charly-u", "lastName": "Brown" }
];

console.log(filterBy(users, { "username" : "Alice" }));
console.log(filterBy(users, { "username" : "charly", "firstName": "Charly-u" }));

answered Sep 25, 2018 at 2:33

Amadan

200k23 gold badges252 silver badges321 bronze badges

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

1 Comment

A l w a y s S u n n y Over a year ago

thumbs up for a generic solution with criteria :)

A l w a y s S u n n y · Accepted Answer · 2018-09-25 02:34:29Z

1

Why not Array.prototype.filter()? to filter only the element that has username="Alice". By the way you can add multiple object keys inside your filter's arrow function while filtering array of object. For example:

user.username ==='Charly' && firstName==='Charly-u'

users = [{
    "username": "Alice",
    "firstName": "Alice-U",
    "lastName": "Wonderland"
  },
  {
    "username": "bob",
    "firstName": "Bob-u",
    "lastName": "Builder",
  },
  {
    "username": "charly",
    "firstName": "Charly-u",
    "lastName": "Brown",
  }
];

result = users.filter(user => user.username ==='Alice');

console.log(result);

answered Sep 25, 2018 at 2:34

A l w a y s S u n n y

38.8k9 gold badges68 silver badges120 bronze badges

Comments

Terry D · Accepted Answer · 2018-09-25 02:37:08Z

1

can’t it be just a function with for loop? //call this.filterIt( ‘username’ , ‘Alice’, users);

//function
Function filterIt (key, value, arr){
result = [];
for ( a in arr){
   if (a[key] == value) result.push(a);
}
return result;
}

answered Sep 25, 2018 at 2:37

Terry D

3693 silver badges15 bronze badges

Comments

Sandip Nirmal · Accepted Answer · 2018-09-25 02:51:42Z

You can write it in the following way. If you want to do exact search write a search function like this:

function search(term) {
  return users.filter(({username, firstName, lastName}) => {
    return username.toLowerCase() === term.toLowerCase() ||
          firstName.toLowerCase() === term.toLowerCase() ||
          lastName.toLowerCase() === term.toLowerCase()
  })
}

Instead of comparing each key one can iterate all object properties using object.keys.

If you want to match each anything use following function

function search(term) {
  return users.filter(({username, firstName, lastName}) => {
    return username.toLowerCase().indexOf(term.toLowerCase()) > -1 ||
           firstName.toLowerCase().indexOf(term.toLowerCase()) > -1 ||
           lastName.toLowerCase().indexOf(term.toLowerCase()) > -1
   })
}

This will even match searchTerm anywhere. Like if you use this as search('al'). It will return the first object, whereas the first function will need exact string like search('alice') to work.

const users = [{
    "username": "Alice",
    "firstName": "Alice-U",
    "lastName": "Wonderland"
  },
  {
    "username": "bob",
    "firstName": "Bob-u",
    "lastName": "Builder",
  },
  {
    "username": "charly",
    "firstName": "Charly-u",
    "lastName": "Brown",
  }
]

function searchFull(term) {
  return users.filter(({
    username,
    firstName,
    lastName
  }) => {
    return username.toLowerCase() === term.toLowerCase() ||
      firstName.toLowerCase() === term.toLowerCase() ||
      lastName.toLowerCase() === term.toLowerCase()

  })

}


function search(term) {
  return users.filter(({
    username,
    firstName,
    lastName
  }) => {
    return username.toLowerCase().indexOf(term.toLowerCase()) > -1 ||
      firstName.toLowerCase().indexOf(term.toLowerCase()) > -1 ||
      lastName.toLowerCase().indexOf(term.toLowerCase()) > -1

  })

}

console.log(searchFull('alice'))
console.log(search('al'))

Collectives™ on Stack Overflow

Filter JSON object array on multiple values or arguments javascript

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related