Filtering an array
Hi, my question is very simple. For a column, let's call it transportation.
{
"transportation": {
"array_contains": [
"bike"
]
}
}
This would work well. However, when I want to get all the rows without bike in transportation column, it doesn't work anymore. I have tried to put "bike" in an array or just as a string, both didn't work. Is this a bug of prisma or did I do something wrong here?
{
"transportation": {
"not": {
"array_contains": [
"bike"
]
}
}
}
{
"transportation": {
"array_contains": [
"bike"
]
}
}
This would work well. However, when I want to get all the rows without bike in transportation column, it doesn't work anymore. I have tried to put "bike" in an array or just as a string, both didn't work. Is this a bug of prisma or did I do something wrong here?
{
"transportation": {
"not": {
"array_contains": [
"bike"
]
}
}
}
