topic Re: How to run a nested loop? in Getting Data In

How to run a nested loop?

aditya — Mon, 29 Mar 2021 04:56:57 GMT

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

Re: How to run a nested loop?

ITWhisperer — Mon, 29 Mar 2021 05:54:35 GMT

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

Re: How to run a nested loop?

aditya — Mon, 29 Mar 2021 06:07:38 GMT

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?

Re: How to run a nested loop?

ITWhisperer — Mon, 29 Mar 2021 06:19:41 GMT

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)

Re: How to run a nested loop?

aditya — Mon, 29 Mar 2021 09:59:30 GMT

Ok, got it. Thanks for your help!!