Filter on JSON array of object.
Hi everyone,
I'm a bit stuck on a search component, I would like to search on a JSON field, it's an array of objects:
with this query:
Unfortunately, the result is empty.
Did I miss something ? or any other way to handle this search ?
Thx for your help,
Fred
I'm a bit stuck on a search component, I would like to search on a JSON field, it's an array of objects:
[
{
"id": "53",
"type": "freeProduct",
"productId": "10041269944641",
"sortOrder": 1,
"productTitle": "Supporter Rare Scarf",
"luckPercentage": 100
}
]
with this query:
await api.capsuleLog.findMany({
filter: {
rewards: {
matches: {
productId: "10041276334401"
}
}
},
first: 10
});
Unfortunately, the result is empty.
Did I miss something ? or any other way to handle this search ?
Thx for your help,
Fred
