如何在多个dataWeave中为嵌套数组应用筛选器

Question

我试图过滤json有效负载字符[]数组下面的字符串，该数组的结果为"valid"，数据[]数组名称为"WBB"，优先级为"1">

我试过下面的代码，但没有工作，有人能帮我吗？。

flatten(payload.offers.category.characters) filter ((item, index) -> item.result=='valid' and flatten(item.data) filter ((item, index) -> item.name=='WBB' and item.priority==1))

Json有效载荷

{
"offers": [
{
"id": 100,
"name": "Test1",
"category": {
"characters": [
{
"result": "valid",
"data": [
{
"name": "WBB",
"priority": 1
},
{
"name": "ILL",
"priority": 2
}
]
}
]
}
},
{
"id": 200,
"name": "Test2",
"category": {
"characters": [
{
"data": [
{
"name": "ISS",
"priority": 1
},
{
"name": "ILL",
"priority": 2
}
]
}
]
}
},
{
"id": 300,
"name": "Test3",
"category": {
"characters": [
{
"data": [
{
"name": "WSS",
"priority": 1
},
{
"name": "ILL",
"priority": 2
}
]
}
]
}
}
]
}

预期有效载荷

[
{
"name": "WBB",
"priority": 1
}
]

Answer 1

flatten((flatten(payload.offers..characters) filter $.result == "valid").data) filter ($.name=="WBB" and $.priority  == 1)

Answer 2

压平(有效负载..数据(筛选器((项，索引(->item.name=='WBB'(