Filter an Data Array with two dimensional filter array which can change over time

Question

I am trying to filter an data array of objects with an two dimensional filter array of objects.

My Data array looks something like this:

dataArray = [{
    Filter_GroupSize: "1"
    Filter_Time: "5-30"
    title: "Tools Test 1"
}, {
    Filter_GroupSize: "5-10"
    Filter_Time: "60-120"
    title: "Tools test 2"
}, {
    Filter_GroupSize: "5-10"
    Filter_Time: "120-240"
    title: "Tools 3"
}, {
    Filter_GroupSize: "10-20"
    Filter_Time: "240-360"
    title: "Tools Test 4"
}]

The thing is that the two dimensional filter array can change over time. In my example down here it has the length of 2. But over time it can get bigger or smaller. If the 2D filter array changes so does the dataArray.

Heres how my two dimensional filter array of objects looks like now.

FiltersToApply = [
    [{
        choice: "5-10"
        internalColName: "Filter_GroupSize"
    }, {
        choice: "10-20"
        internalColName: "Filter_GroupSize"
    }],
    [{
        choice: "60-120"
        internalColName: "Filter_Time"
    }, {
        choice: "120-240"
        internalColName: "Filter_Time"
    }]
]

I want to filter through the data array and only return element that has both the values of the "Filter_GroupSize" and "Filter_Time" from the 2D Filter Array. In this example i would want to have the "Tools test 2" and "Tools 3" element returned in a new array. I want a filter function that checks the "FiltersToApply[0]" and if it finds a match it checks the "FiltersToApply[1]" for match on the same element from the dataArray.

I have come this far with the code:

            for (let i = 0; i < FiltersToApply.length; i++) {
                console.log(FiltersToApply[i]);
                FiltersToApply[i].forEach((filter) => {
                    var filteredArray: Tool[] = dataArray.filter((item) => {
                        if (item[filter.internalColName] == filter.choice && ((i+1) <= FiltersToApply.length)) {
                            this.nextArray(FiltersToApply[i+1], item);
                        }
                    });
                });
            }

But i am stuck here. Anyone have a good solution?

Please take a look here: https://stackoverflow.com/questions/23600897/using-lodash-groupby-how-to-add-your-own-keys-for-grouped-output — Mor Shemesh, Dec 02 '19 at 10:30

score 0 · Answer 1 · answered Dec 02 '19 at 10:45

I got it working with below snippet, basically flatted the filter array and grouped them with property names, and then filtered against that.

var dataArray = [{
    Filter_GroupSize: "1",
    Filter_Time: "5-30",
    title: "Tools Test 1"
}, {
    Filter_GroupSize: "5-10",
    Filter_Time: "60-120",
    title: "Tools test 2"
}, {
    Filter_GroupSize: "5-10",
    Filter_Time: "120-240",
    title: "Tools 3"
}, {
    Filter_GroupSize: "10-20",
    Filter_Time: "240-360",
    title: "Tools Test 4"
}];

var FiltersToApply = [
    [{
        choice: "5-10",
        internalColName: "Filter_GroupSize"
    }, {
        choice: "10-20",
        internalColName: "Filter_GroupSize"
    }],
    [{
        choice: "60-120",
        internalColName: "Filter_Time"
    }, {
        choice: "120-240",
        internalColName: "Filter_Time"
    }]
];

// flat the filter array to get a linear format, then group by properties to combine choices
var filterArr = FiltersToApply.flat().reduce(function (a, cv) {
    (a[cv.internalColName] = a[cv.internalColName] || []).push(cv.choice);
    return a;
}, []);

var result = dataArray.filter(function(v){
    return filterArr.Filter_GroupSize.indexOf(v.Filter_GroupSize) > -1 && filterArr.Filter_Time.indexOf(v.Filter_Time) > -1
});

console.log(result.map(function(v){ return v.title; }))

Filter an Data Array with two dimensional filter array which can change over time

1 Answers1