Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

jquery grep on json object array

Im trying to use grep to filter a json object array so that the array is searched and if the value of any of keys #2-6 are yes, the value of keys 1 and 7 are returned.

The array is below -- in other words, if any of values for the 'location' keys are yes, the name and description are returned as list items.

Any help is VERY much appreciated.

[
    {
        "name": "name",
        "location1": "no",
    "location2": "no",
    "location3": "yes",
    "location4": "no",
    "location5": "no",
    "description": "description of services"
    },

    {   
    "name": "name",
        "location1": "yes",
    "location2": "no",
    "location3": "yes",
    "location4": "no",
    "location5": "no",
    "description": "description of services"        
    }
]
like image 742
sharpiemarker1 Avatar asked Jun 07 '11 19:06

sharpiemarker1


2 Answers

You will need to use both grep and map. If a is the array described above (but with name1, name2, etc), then after the following:

var b = $.grep(a, function(el, i) {
    return el.location1.toLowerCase() === "yes" 
           || el.location2.toLowerCase() === "yes" 
           || el.location3.toLowerCase() === "yes" 
           || el.location4.toLowerCase() === "yes" 
           || el.location5.toLowerCase() === "yes";
});

var c = $.map(b, function(el, i) {
    return {
        name: el.name,
        description: el.description
    };
});

c will contain [{"name":"name1","description":"description of services1"},{"name":"name2","description":"description of services2"}]

See example →

like image 167
mVChr Avatar answered Nov 17 '22 11:11

mVChr


My version is very similar to previous answer, I hope it helps:

    var checkYes = function(element) {

        var isYesInside = false;

        $.each(element, function(key, value) {
            if (value == "yes")
                isYesInside = true;
        });

        return isYesInside;
    };

    var yeses = $.grep(a, function(element, index) {
        return checkYes(element);
    });

    var finalArray = $.map(yeses, function(el, i) {
        return {
            name: el.name,
            description: el.description
        };
    });
like image 21
Deleted because of negativity Avatar answered Nov 17 '22 12:11

Deleted because of negativity