How to get/filter all results from JSON file with underscore.js

Question

I have this (shortened for question) JSON file:

[
  {
   "product":"aardappelen gebakken",
   "quantity":"100gr",
   "carbohydrates":"19,3"
  },
  {
   "product":"aardappelen pikant",
   "quantity":"100gr",
   "carbohydrates":"3"
  },

  {
   "product":"aardappelmeel",
   "quantity":"100gr",
   "carbohydrates":"80"
  }
]

Wat i want to do is:

search for a product, and result all of its content, like when i would search for "aardappelmeel", i get product, quantity and carbohydrates key value, i do this with this code:

the search term is hardcoded for the moment, this will be a var later one.

$(function() {

    $.getJSON( "js/data.json").fail(function(jqxhr, textStatus, error) {
    var err = textStatus + ", " + error;
    console.log( "Request Failed: " + err );
    }).done(function(data) {
    var carbohydratesResult = getCarbohydrates(data, 'aardappelmeel');
    console.log(carbohydratesResult);
  });

});

function getCarbohydrates(arr, searchTerm){
  var result;
  if(searchTerm === '') {
    result = 'No searchterm';
  }
  else {
    result = _.where(arr, {product: searchTerm});
  }
 return result;
}

This gets 1 result:

enter image description here

Question: When i search for "aardappelen", i get no result, and it should be 2, because there are 2 products that contain the name "aardappelen". How do i do this?

I use jQuery, Underscore. If Underscore is not needed for this, fine by me, please show me how i modify my code to get more then one result when "product" value contains the search term.

This should answer your question: stackoverflow.com/q/17099029/218196. If you want to test whether a string is contained in another string, use .indexOf: developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/…. — Felix Kling
– Felix Kling, Commented Dec 5, 2013 at 17:21

McGarnagle · Accepted Answer · 2013-12-05 17:53:56Z

2

You need _.filter along with indexOf to do a substring search:

result = _.filter(arr, function(item) {
    return item.product && item.product.indexOf(searchTerm) != -1;
});

Note that _.where performs an exact match.

edited Dec 5, 2013 at 17:53

answered Dec 5, 2013 at 17:29

McGarnagle

103k31 gold badges235 silver badges264 bronze badges

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

2 Comments

Felix Kling Over a year ago

You linked to indexOf for arrays. I believe that indexOf for strings is supported by every browser.

McGarnagle Over a year ago

@FelixKling d'oh, thanks. You're right, indexOf was implemented in Javascript 1.0.

cpreid · Accepted Answer · 2013-12-05 17:32:33Z

1

I would probably say underscore is not needed for this (not optimal to include an entire js library just use use a single function). Searching for text simply in JavaScript is never fun. You're probably best writing some regex function that loops over your result set and tries to match some text.

If possible, I would try to implement the searching functionality on the server side, and return those results in an ajax request.

Rough example of a JS Solution...

var searchText = 'blah',
    matches = [];
for(var i = 0; i < results.length; i++) {
    var reg = new RegExp(searchText);
    if(results[i].product.match(reg)) matches.push(results[i]);
}

return matches;

edited Dec 5, 2013 at 17:32

answered Dec 5, 2013 at 17:25

cpreid

6214 silver badges12 bronze badges

Collectives™ on Stack Overflow

How to get/filter all results from JSON file with underscore.js

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related