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
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
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
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?
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)
Ok, got it. Thanks for your help!!