Filter the json object

kasim mohamed

6y1.3kTypeScript

const base = [

{id: 1,name: 'A1'}, {id: 11,name: 'A11'},

{id: 12,name: 'A2'}, {id: 111,name: 'A111'},

{id: 112,name: 'A112'}, {id: 121,name: 'A121'},

{id: 122,name: 'A122'},

{id: 2,name: 'A2'},{id: 3,name: 'A3'},{id: 4,name: 'A4'}

];

const tree = [

{id: 1, parent:0, level: 'L1'},

{id: 11, parent:1, level: 'L2'},

{id: 111, parent:11, level: 'L3'},

{id: 112, parent:11, level: 'L3'},

{id: 12, parent:1, level: 'L2'},

{id: 121, parent:12, level: 'L3'},

{id: 122, parent:12, level: 'L3'},

]

i have two object one is base another one is tree. if i pass the 'id=11' it has to remove the [id:11]'s level 'L2' and its top level 'L1' id from the base object and result the remaining values. the below result am expecting

const result = [

{id: 111,name: 'A111'},

{id: 112,name: 'A112'}, {id: 121,name: 'A121'},

{id: 122,name: 'A122'},

{id: 2,name: 'A2'},{id: 3,name: 'A3'},{id: 4,name: 'A4'}

];

how to achieve this?

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vikas Jha6y ago
Accepted answer
Hi Kasim,

As you have shared the nested array for data so I have updated the code to get ID if array item has ID. Please check below updated code and screen shot the console. If you want to change the array schema then you have to make code.
const base = [
    {id: 1,name: 'A1'},
    {id: 11,name: 'A11'},
    {id: 12,name: 'A2'},
    {id: 111,name: 'A111'},
    {id: 112,name: 'A112'},
    {id: 121,name: 'A121'},
    {id: 122,name: 'A122'},
    {id: 2,name: 'A2'},
    {id: 3,name: 'A3'},
    {id: 4,name: 'A4'}
    ];
    data = [
        {
           id: 1457,
           parentid: 0,
           level: 'L1',
           children:
                       [
                          {id: 1458, parentid: 1457, level: 'L2'},
                          {id: 1459, parentid: 1457, level: 'L2'}
                       ]
        }
]
    const tree = [
    {id: 1, parent:0, level: 'L1'},
    {id: 11, parent:1, level: 'L2'},
    {id: 111, parent:11, level: 'L3'},
    {id: 112, parent:11, level: 'L3'},
    {id: 12, parent:1, level: 'L2'},
    {id: 121, parent:12, level: 'L3'},
    {id: 122, parent:12, level: 'L3'},
    ];
    const valueToRemove = 11;
    const result = [];
    result.pop();


function filterArray(){
    var itemIndexinTree = tree.findIndex(c => c.id == valueToRemove);
    var markedItem = tree.find(t => t.id == valueToRemove);
    var markedItemLevel = markedItem.level;
    var markedItemLevelNo = markedItemLevel.split('L')[1];
    var levelToSkip = [];
    for (let index =1 ; index <=  markedItemLevelNo; index++) {
        levelToSkip.push("L"+index);
    }
    console.log("Levels To Skip :" +levelToSkip);
    var idsToSkip = [];
    for (let indexforSkip = 0; indexforSkip < levelToSkip.length; indexforSkip++) {
        data.forEach((item)=>{ debugger;
               if(item.level == levelToSkip[indexforSkip]){
                idsToSkip.push(item.id);
               }

            if(item.children.length > 0){
                    for (let cindex = 0; cindex < item.children.length; cindex++) {
                        if(item.children[cindex].level == levelToSkip[indexforSkip]){
                            idsToSkip.push(item.children[cindex].id);
                        }

                    }
              }

        });
    }
    console.log("Selected IDs To Skip "+idsToSkip);
    base.forEach((item)=>{ debugger;
         if(idsToSkip.indexOf(item.id) < 0){
           result.push(item);
           }
        });
        console.log(result);

}
Note : Please accept the answer as solution.
+4
kasim mohamed6y ago
The array would be dynamic... anyway thanks vikas.
+2
Vikas Jha6y ago
Hi Kasim,

Code will work even if you pass L3 but first you need to make sure that Schema of array is consistent , so that we can make it work in foreach loop. This time I have left debugger in code shared with you. If your schema is fix then you can debug and make the change , which we will work for scenario and levels.
If required you can share the data array and I can try to make code change and share with you.
0
kasim mohamed6y ago
Hi Vikas,
Thank you very much for your solution. its working great for my current scenario.
but incase in future if i pass level 'L3', it wont work. can you please guide me
if i pass at any level, it has to loop through its level and bring it dynamically like a recursive.
+2
Laxmidhar Sahoo6y ago
hi
var sid = 11;
tree.forEach((titem)=>{

      if(titem.id == sid){
                base.forEach((bitem)=>{

              // check bitem.id== titem.id or  bitem.id== titem.parent

                //splice
             });
           }
     });
Thanks and regards
+1
Vikas Jha6y ago
Hi Kasim, What json object, you posted earlier . Code is working and giving expected result. Now what json data you posted is nested one and now you have to make the adjustments to the code to get the result. If I will get time, I will try to work on it and share the code.
+2
kasim mohamed6y ago
Hi Vikas,

This is my levelToSkip and data object

levelToSkip = ['L1','L2']

data = [

            {

               ledgerid: 1457,

               parentid: 0,

               level: 'L1',

               children:

                           [

                              {ledgerid: 1458, parentid: 1457, level: 'L2'},

                              {ledgerid: 1459, parentid: 1457, level: 'L2'}

                           ]

            }

]

please run the screen shot code which you given. for loop has to produce 'idsToSkip' as [1457,1458,1459]

because 'levelToSkip' having both 'L1' and 'L2'
+3
Vikas Jha6y ago
Hi Kasim, I tested the code, it is giving me all the IDs to skip. Just to note , code did not handle case sensitivity (upper case and lower case) so it should be upper case always. Still if you facing the issue the pleaSe post the arrays so that I can check with code.
+2
kasim mohamed6y ago
Hi vikas,
thanks for the reply.

your code is working fine. but i have one issue please attached the screen the levelToSkip have 'L1' and 'L2'
my data object have L1(1457) under that L2(1458,1459).
after the for loop 'idsToSkip' variable having only 1457. but actually it should have 1457,1458,1459.
what is the mistake in the below code?

+3
Vikas Jha6y ago
Hi Kasim,
I tried a solution for you. Please have a look as it will give u desired result.
const base = [
    {id: 1,name: 'A1'},
    {id: 11,name: 'A11'},
    {id: 12,name: 'A2'},
    {id: 111,name: 'A111'},
    {id: 112,name: 'A112'},
    {id: 121,name: 'A121'},
    {id: 122,name: 'A122'},
    {id: 2,name: 'A2'},
    {id: 3,name: 'A3'},
    {id: 4,name: 'A4'}
    ];
    const tree = [
    {id: 1, parent:0, level: 'L1'},
    {id: 11, parent:1, level: 'L2'},
    {id: 111, parent:11, level: 'L3'},
    {id: 112, parent:11, level: 'L3'},
    {id: 12, parent:1, level: 'L2'},
    {id: 121, parent:12, level: 'L3'},
    {id: 122, parent:12, level: 'L3'},
    ];
    const valueToRemove = 11;
    const result = [];
    result.pop();

function filterArray(){
    var itemIndexinTree = tree.findIndex(c => c.id == valueToRemove);
    var markedItem = tree.find(t => t.id == valueToRemove);
    var markedItemLevel = markedItem.level;
    var markedItemLevelNo = markedItemLevel.split('L')[1];
    var levelToSkip = [];
    for (let index =1 ; index <=  markedItemLevelNo; index++) {
        levelToSkip.push("L"+index);
    }
    var idsToSkip = [];
    for (let indexforSkip = 0; indexforSkip < levelToSkip.length; indexforSkip++) {
        tree.forEach((item)=>{
               if(item.level == levelToSkip[indexforSkip]){
                idsToSkip.push(item.id);
               }
        });
    }
    base.forEach((item)=>{ debugger;
         if(idsToSkip.indexOf(item.id) < 0){
           result.push(item);
           }
        });
        console.log(result);
}
Note: Please accept it as a solution if it meets your requirment.
+3