How to get values.status value when values.name.value=text from the json.
$.values[?(@.name[?(@.language=='EN' && @.value=='test')])].status
is giving more than 2 status values
{"values":[
{"name":[{"language":"EN","value":"text"},
{"language":"DE","value":"text"}],
"status":"active"},
{"name":[{"language":"EN","value":"test2"},
{"language":"DE","value":"test2"}],
"status":"active"}
]
}