How to run a nested loop?

[aditya]

Hi,

I have one field containing an array within an array.

How can I run a for loop to query the nested arrays and display them?

Eg :-

Dept_details : [

{name:"cse", HOD:"somename", students:[

{name:"aditya", rollNo:"1"}, {name:"akash", rollNo="2"}

]

},

{

name:"ece", HOD:"somename2", students:[

{name:"abhiram", rollNo:"1"}, {name:"abhay", rollNo="2"}

]

}

]

I expect the results to be like this :-

Dept_details

name                    hod

cse                        someone

student details

name                 rollNo

aditya                1

akash                  2

dept details

name                    hod

ise                        someone2

student details

name                 rollNo

abhiram           1

abhay               2

Thanks,

Aditya

[ITWhisperer · Accepted solution]

I am not sure you can easily get the representation you are showing, however,  you could try something like this to break up the data

| spath path=Dept_details output=Dept_details
| mvexpand Dept_details
| spath input=Dept_details

[aditya]

Hi @ITWhisperer ,

The events which are getting logged for my project can have same id. So, on running mvexpand, it lists the contents of all array of all events. That's why I need to run a for loop somehow. Otherwise I can't calculate no of depts in dept_details.

Can you help with this?

[ITWhisperer]

I am not sure where id is coming from since it isn't in the example you shared - if you need the count of dept_details

| spath path=Dept_details output=Dept_details
| eval Dep_t_count=mvcount(Dept_details)

[aditya]

Ok, got it. Thanks for your help!!