Filter a multidimensional json array by specific element with jquery

Question

I have the following json array:

{"0":  
   {"ChkSystem":
      {"id":"847",
       "item":"1",
       "fase":"#FE99CC",
       "description":"some info.",
       "image_path":"",
       "pm_id":"461",
       "main_systems_id":"1"
      }
   },
 "1":
   {"ChkSystem":
      {"id":"846",
       "item":"1",
       "fase":"#FE99CC",
       "description":"some data",
       "image_path":"",
       "pm_id":"461",
       "main_systems_id":"2"
      }
   },
"2":
  {"ChkSystem":
     {"id":"856",
      "item":"2",
      "fase":"#FE99CC",
      "description":"some data.",
      "image_path":"",
      "pm_id":"461",
      "main_systems_id":"2"
     }
  }
}

How can I filter it by "main_systems_id" with jquery?
The problem is the key is variable ("0", "1" and so on) and in other posts that I had read that key is always the same.

Thanks in advance for your answers.

Just out of curiosity... why you use `"0", "1", "2"` object properties instead of using an Array of objects? Array is already indexed. — Roko C. Buljan, Jun 10 '14 at 22:47
Hi @adeneo, for example posted above, I want all `"ChkSystem"` arrays where `"main_systems_id"` are equal to `"2"` — Franchy, Jun 10 '14 at 22:50
Hi @RokoC.Buljan the array is in this form because is a php array generated by a cakephp query — Franchy, Jun 10 '14 at 22:54
@Efraín if your cakephp query was setup by a human... he was most probably in love... — Roko C. Buljan, Jun 10 '14 at 22:57

Nijikokun · Accepted Answer · 2014-06-10T22:58:43.973

1

I think a tool like lodash or underscore is more suited for something of this nature.

However should you really want to do it with jQuery:

function filterByMainSystemsId (object, value) {

  // The real meat of the solution, you can use this directly if you want.
  return $.map(object, function (item, key) { 

      // this is where the check is done
      if (item.ChkSystem.main_systems_id === value) {

        // if you want the index or property "0", "1", "2"... etc.
        // item._index = key;

        return item; 
      }
    });
  };
}

var object = /* ... your object goes here ... */;
var array = filterByMainSystemsId(object, "2") // [ { ... }, { ... } ]

I agree however, this should be an array and not an object, but things like elasticsearch and other tools make this hard and I can understand that.

edited Jun 10 '14 at 22:58

answered Jun 10 '14 at 22:52

Nijikokun

1,514
1
15
22

Hi @Nijikokun thank for your answer, your code work perfectly but how can I do to get the object in plain object? I mean the form I posted in my question `{{...}}` – Franchy Jun 11 '14 at 21:03
I've created a jsfiddle showing how you could do this here http://jsfiddle.net/Nijikokun/J8A68/ instead of returning the array from $.map, just add each item to an object and return the object instead. – Nijikokun Jun 12 '14 at 21:39

score 0 · Answer 2 · edited May 23 '17 at 12:06

This is not an array, but an object, containing sub objects. This would be the code for a json array:

[
{"ChkSystem":
      {"id":"847",
       "item":"1",
       "fase":"#FE99CC",
       "description":"some info.",
       "image_path":"",
       "pm_id":"461",
       "main_systems_id":"1"
      }
   },
   {"ChkSystem":
      {"id":"846",
       "item":"1",
       "fase":"#FE99CC",
       "description":"some data",
       "image_path":"",
       "pm_id":"461",
       "main_systems_id":"2"
      }
   },
  {"ChkSystem":
     {"id":"856",
      "item":"2",
      "fase":"#FE99CC",
      "description":"some data.",
      "image_path":"",
      "pm_id":"461",
      "main_systems_id":"2"
     }
  }
]

but you can also loop through json objects (key value pairs) and furthermore filter them. See StackOverflow: loop and get key/value pair for JSON array using jQuery

Filter a multidimensional json array by specific element with jquery

2 Answers2