Hi I have a hard tim understanding the "in" part o...
# orm-helpc
Christophe Rudyj
07/11/2022, 12:32 PMHi I have a hard tim understanding the "in" part of Prisma as i'm trying to get items from an array
Copy code
['Kala','Modern Horizon']👀 1
v
Vladi Stevanovic
07/11/2022, 2:49 PM
@Christophe Rudyj thank you for joining the Prisma community and sharing your questions here. I believe that you may have received a suggestion a few posts down.
One minor ask if you don’t mind: it would be great if you could use Slack’s thread feature when responding to users. This helps keep the main conversation channel a bit more clear 🙏
c
Christophe Rudyj
07/11/2022, 3:17 PMhow do i do that?
v
Vladi Stevanovic
07/11/2022, 3:22 PM
Here are the steps, it's super quick:
1. Post a single message in #general summarizing your issue or question
2. Hover over your message and click on the 💬 that appears in the options bar, to start a thread
3. Add any additional information directly in the thread!
Vladi Stevanovic
07/11/2022, 3:23 PM
Let me know if you have any other questions!
c
Christophe Rudyj
07/12/2022, 12:31 AMis there any one that could help?
v
Vladi Stevanovic
07/12/2022, 7:03 AM
@Christophe Rudyj I see that the suggestion here didn't work. : https://prisma.slack.com/archives/CA491RJH0/p1657542915887169
I'll ping the team to see if anyone can help. In the meantime, I'll consolidate your posts here, so that we know where to answer.
Vladi Stevanovic
07/12/2022, 7:04 AM
Original post:
Copy code
But in the studio the item are thereVladi Stevanovic
07/12/2022, 7:04 AM
Copy code
if i try to run this filter it failsVladi Stevanovic
07/12/2022, 7:05 AM
Copy code
if try to run this one it also failsVladi Stevanovic
07/12/2022, 7:05 AM
here is the schema for box:
Copy code
model Box {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
set String @db.VarChar(255)
set_rel Sets @relation(fields: [set], references: [name])
box_number String @db.VarChar(100)
box_second_number String? @db.VarChar(100)
game_id Int? @default(1)
game_rel Games? @relation(fields: [game_id], references: [id])
store_id Int?
store_rel Store? @relation(fields: [store_id], references: [id])
}n
nikolasburk
07/12/2022, 8:21 AM
Hey @Christophe Rudyj, could you also share the
Setsc
Christophe Rudyj
07/12/2022, 3:51 PM Copy code
model Sets {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
name String @unique @db.VarChar(255)
code String? @db.VarChar(255)
game_id Int? @default(1)
game_rel Games? @relation(fields: [game_id], references: [id])
edition String?
children String[]
in_boxes Box[]
}3 Views