Jquery grep or map object array with multiple search criterias

Question

I have a price list in JSON:

  {Products: [{AdminID: 137, ProduktID: "07.1434", itemName: "Repaplast", itemColor: "0000, 5030", MalKode: "1-3", …}{AdminID: 6, ProduktID: "07.1436", itemName: "Repaplast grå", itemColor: "0070", MalKode: "1-3", …}{AdminID: 146, ProduktID: "90.0905", itemName: "Mixer Gun", itemColor: null, MalKode: "", …}{AdminID: 89, ProduktID: "02.0135", itemName: "Repaplast Primer NEW FORMULA", itemColor: "", MalKode: "5-3", …}]}

The list is about 400 products long.

Say I want to limit the list showing only specific products based on the field ProduktID (which is unique). Let's say I have a list of products in an offer:

07.1438, 01, 1340, 05, 04531, 02.0135

Where comma is the separator.

How can I .grep or .map the objects array based on these inputs? Do I have to search one by one and then combine the results into another object? Or is there a faster way?

Hassan Imam · Accepted Answer · 2017-10-05 06:24:19Z

1

You can use array#filter and array#find. It will result in filtering the products based on the product ids string.

const productIds = '07.1438, 01,1340, 05,04531, 02.0135';

const products = [{AdminID: 137, ProduktID: "07.1438", itemName: "Repaplast", itemColor: "0000, 5030", MalKode: "1-3",},{AdminID: 6, ProduktID: "07.1436", itemName: "Repaplast grå", itemColor: "0070", MalKode: "1-3",},{AdminID: 146, ProduktID: "90.0905", itemName: "Mixer Gun", itemColor: null, MalKode: "",},{AdminID: 89, ProduktID: "02.0135", itemName: "Repaplast Primer NEW FORMULA", itemColor: "", MalKode: "5-3",}];

var result = products.filter( o => productIds.split(',').find(productId => o.ProduktID === productId.trim()));

console.log(result);

answered Oct 5, 2017 at 6:24

Hassan Imam

22.6k6 gold badges45 silver badges53 bronze badges

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

1 Comment

XanderMan Over a year ago

I still get error on the "filter" keyword. Error sais: "products.filter is not a function"

wscourge · Accepted Answer · 2017-10-05 06:20:34Z

1

Use Array.prototype.filter() combined with Array.prototype.includes():

const wanted   = ['07.1438', '01','1340', '05', '04531', '02.0135'];
const products = [
  {
    AdminID  : 137, 
    ProduktID: "07.1434", 
    itemName : "Repaplast", 
    itemColor: "0000, 5030", 
    MalKode  : "1-3"
  },
  {
    AdminID  : 6, 
    ProduktID: "07.1436", 
    itemName : "Repaplast grå", 
    itemColor: "0070", 
    MalKode  : "1-3"
  },
  {
    AdminID  : 146, 
    ProduktID: "90.0905", 
    itemName : "Mixer Gun", 
    itemColor: null, 
    MalKode  : ""
  },
  {
    AdminID  : 89, 
    ProduktID: "02.0135", 
    itemName : "Repaplast Primer NEW FORMULA", 
    itemColor: "", 
    MalKode  : "5-3"
  }
];

const filtered = products.filter((product) => wanted.includes(product.ProduktID));
console.log("Filtered", filtered);

edited Oct 5, 2017 at 6:20

answered Oct 5, 2017 at 6:10

wscourge

11.4k17 gold badges65 silver badges87 bronze badges

6 Comments

XanderMan Over a year ago

It really looks like a great answer. Thank you. I will test it.

XanderMan Over a year ago

BUT where does the word "PRODUCT" come into play? you call the array "productS" I see no mention of "product" anywhere in the code except in the const filtered ??

wscourge Over a year ago

products.filter((----->product<-----) => { ... }) - it is an argument of the array function passed to the .filter() method

XanderMan Over a year ago

I get an error: "filter is not a function". when I try to add products.filter(...) Do I have to convert the products array in some special manner ?

XanderMan Over a year ago

i see now that my array is formatted sligthly different than in my initial question: it is really: {"products":[{"AdminID":491,"ProduktID":"01.0635","itemName":"ClearBond .... }]...}

|

Collectives™ on Stack Overflow

Jquery grep or map object array with multiple search criterias

2 Answers 2

1 Comment

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related