P
Prisma3mo ago
Backxtar

How to filter table for json data?

i got this
async function getData() {
const data = await prisma.assets.findMany({
where: {
key: "heroes-data",
body: {
path: ["$[*].id"],
equals: "1",
},
},
select: {
body: true,
},
});
console.log(data);
}
async function getData() {
const data = await prisma.assets.findMany({
where: {
key: "heroes-data",
body: {
path: ["$[*].id"],
equals: "1",
},
},
select: {
body: true,
},
});
console.log(data);
}
The json inside is something like
[
{
"id": 1,
"class_name": "hero_inferno",
"name": "Infernus",
"description": {
"lore": "Like most teenagers; Infernus was wild, rebellious, and impetuous. Unlike most teenagers, Infernus was a creature from another plane and had a supernatural mastery over fire. Needless to say: his youth was filled with no small amount of arson, murder, and evidence disposal. But that was then. Now an adult, Infernus has mellowed out considerably. He’s happy working at a bar with good live music, and talking to interesting people. That being said when someone at the bar gets belligerent or violent, he’s not afraid to dust off the skills he once honed.",
"role": "Lights up enemies and watches them burn",
"playstyle": "Infernus has many ways to deal damage over time, burning foes before swooping in for the kill. Due to Infernus' blazing speed, his enemies won't be able to escape the flames."
},
{...}
]
[
{
"id": 1,
"class_name": "hero_inferno",
"name": "Infernus",
"description": {
"lore": "Like most teenagers; Infernus was wild, rebellious, and impetuous. Unlike most teenagers, Infernus was a creature from another plane and had a supernatural mastery over fire. Needless to say: his youth was filled with no small amount of arson, murder, and evidence disposal. But that was then. Now an adult, Infernus has mellowed out considerably. He’s happy working at a bar with good live music, and talking to interesting people. That being said when someone at the bar gets belligerent or violent, he’s not afraid to dust off the skills he once honed.",
"role": "Lights up enemies and watches them burn",
"playstyle": "Infernus has many ways to deal damage over time, burning foes before swooping in for the kill. Due to Infernus' blazing speed, his enemies won't be able to escape the flames."
},
{...}
]
but i cant get data back .. 😦
1 Reply
Nurul
Nurul3mo ago
Can you share your assets model?
Want results from more Discord servers?
Add your server