Filtering Data by AlaSQL,js

filter-by-alasql.js

// var filters = {id: 2}; // passed: true
    // var filters = {id: 2, name: 'name_2'}; // passed: true
    // var filters = {
    //     id: 2,
    //     name: 'name_1'
    // }; // passed = true
//     var filters = {
//     id: 1,
//     name: 'name_1',
//     list: {
//         subnome: "nome_sub_1"
//     }
//
// }; // passed: true
    // var filters = {
    //     id: 1,
    //     name: 'name_1',
    //     list: {
    //         subnome: "nome_sub_2"
    //     }
    // };
    var filtered, filterList;
    filtered = alasql('SELECT * FROM ? WHERE id LIKE "'+filters.id+'" AND name LIKE "'+filters.name+'" ',[xml]);
    if (filters.list instanceof Object) {
        filtered = jQuery.grep(filtered, function(v, i){
            var ret = false;
            jQuery.each(v, function(ii,vv){
                if (ii === 'list') {
                    var res = alasql('SELECT * FROM ? WHERE subnome LIKE "'+filters.list.subnome+'"', [vv]);
                    if (res.length > 0) {
                        ret = true
                    }
                }
            });
            return ret;
        });
    }
    console.log(filtered);