| makeresults
| eval jsonTest = "{
\"parent_id\": 1,
\"child_info\": [
{
\"id\": \"123\",
\"status\": \"PASS\"
},
{
\"id\": \"456\",
\"status\": \"FAIL\"
},
{
\"id\": \"457\",
\"status\": \"FAIL\"
}
]
}"
| spath input=jsonTest path=parent_id output=parent_id
| spath input=jsonTest output=id_initial path=child_info{}.id
| spath input=jsonTest output=status_initial path=child_info{}.status
| eval val = mvzip(id_initial, status_initial)
| mvexpand val
| eval mvVal = split(val, ",")
| eval id = mvindex(mvVal, 0)
| eval status = mvindex(mvVal, 1)
| stats count(eval(status=="PASS")) as Child_Passed_count count(eval(status=="FAIL")) as Child_Failed_count by parent_id
parent_id Child_Passed_count Child_Failed_count
1 1 2
... View more