How can I search JSON with jQuery?

Question

I'm using a session storage to temporarily hold data and try to search for a string (CatalogNumber) in the session data. If the string isn't existing I'd like to add it.

This is what I've tried so far but it's still allowing duplicates. And the search isn't working for the array for some reason:

var gridData = {
    catalogNumber: dataItem.CatalogNumber,
    fullName: dataItem.FullName,
    position: dataItem.CurrentTitle
};

sessionStorageData = JSON.parse(sessionStorage.getItem('people'));

if (jQuery.inArray(gridData.catalogNumber, sessionStorageData ) === -1) {
    sessionStorageData.push(gridData);
    sessionStorage.setItem('people', JSON.stringify(sessionStorageData));
}

Data

[{"catalogNumber":"51263bf7-83c4-e411-825d-28b2bd14ba94","fullName":"John Doe","position":"Receptionist"}]

You may be interested in my JSON.search API which is 5x faster than $.grep and allows you to search using regex. See json.spiritway.co — mikewhit
– mikewhit, Commented May 8, 2015 at 20:45

Martin Konecny · Accepted Answer · 2015-05-05 05:59:26Z

1

It makes sense that the array search isn't working.

Your array is an array of objects. You are trying to match a string (in this case gridData.catalogNumber) against those objects.

Solution #1:

If your array was an array of strings, then your search would work. An alternate approach might be:

function found(gridData, sessionStorageData) {
  for (o in sessionStorageData) {
    if (sessionStorageData[o].catalogNumber == gridData.catalogNumber) {
      return true;
    }
  }
  return false;
}

if (!found(gridData.catalogNumber, sessionStorageData )) {
    sessionStorageData.push(gridData);
    sessionStorage.setItem('people', JSON.stringify(sessionStorageData));
}

Solution #2

An even better solution might be to map your array of objects into an array of strings.

var catalogNumbers = sessionStorageData.filter(function(obj){ return !!obj }).map(function(obj) { return obj.catalogNumber; } );
if (jQuery.inArray(gridData.catalogNumber, catalogNumbers ) === -1) {
    sessionStorageData.push(gridData);
    sessionStorage.setItem('people', JSON.stringify(sessionStorageData));
}

edited May 5, 2015 at 5:59

answered May 5, 2015 at 5:28

Martin Konecny

59.9k20 gold badges144 silver badges159 bronze badges

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

8 Comments

redbmk Over a year ago

What is def? Do you mean function?

Barmar Over a year ago

Javascript for-in is not like PHP foreach. o is the key, not the element.

Martin Konecny Over a year ago

@Barmar - was in Python mode there for a bit. Thx.

chris Over a year ago

thank you so much - solution 2 is working great for the most part. I do have a small hiccup tho. When I clear cache & session data the sessionStorageData key 'people' has a value of '[null]' which is causing the following error: Cannot read property 'catalogNumber' of null

Martin Konecny Over a year ago

ok updated answer. Added a filter to remove all "null/undefined" array elements.

|

Collectives™ on Stack Overflow

How can I search JSON with jQuery?

1 Answer 1

Solution #1:

Solution #2

8 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Solution #1:

Solution #2

8 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related