studio
studio copied to clipboard
isNotNull filter not working
In my local prisma studio, when I try to filter a field by isNotNull
the filtering does not work
The value field is highlighted in red and I cannot click inside of it.
I tried upgrading to the latest version of prisma as well as clearing my indexdb for prisma studio.
- Prisma version (
prisma -v
ornpx prisma -v
):
prisma : 4.10.1
@prisma/client : 4.6.0
Current platform : windows
Query Engine (Node-API) : libquery-engine aead147aa326ccb985dcfed5b065b4fdabd44b19 (at ..\..\..\..\AppData\Local\pnpm\store\v3\tmp\dlx-4760\node_modules\.pnpm\@[email protected]\node_modules\@prisma\engines\query_engine-windows.dll.node)
Migration Engine : migration-engine-cli aead147aa326ccb985dcfed5b065b4fdabd44b19 (at ..\..\..\..\AppData\Local\pnpm\store\v3\tmp\dlx-4760\node_modules\.pnpm\@[email protected]\node_modules\@prisma\engines\migration-engine-windows.exe)
Format Wasm : @prisma/prisma-fmt-wasm 4.10.1-1.80b351cc7c06d352abe81be19b8a89e9c6b7c110
Default Engines Hash : aead147aa326ccb985dcfed5b065b4fdabd44b19
Studio : 0.481.0
- Logs from Developer Tools Console or Command line, if any:
-
Does the issue persist even after updating to the latest
prisma
CLI dev version? (npm i -D prisma@dev
) Yes -
Prisma schema (if relevant):
// This is your Prisma schema file,
// learn more about it in the docs: https://pris.ly/d/prisma-schema
datasource db {
provider = "postgresql"
url = env("DATABASE_URL")
}
generator client {
provider = "prisma-client-js"
}
// --------------------------------------
model User {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
name String?
email String @unique
hashedPassword String?
role String @default("USER")
tokens Token[]
sessions Session[]
requestedProblems RequestedProblem[]
referredById Int?
referredBy User? @relation("Referral", fields: [referredById], references: [id])
referred User[] @relation("Referral")
}
model Session {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
expiresAt DateTime?
handle String @unique
hashedSessionToken String?
antiCSRFToken String?
publicData String?
privateData String?
user User? @relation(fields: [userId], references: [id])
userId Int?
}
model Token {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
hashedToken String
type TokenType
expiresAt DateTime
sentTo String
user User @relation(fields: [userId], references: [id])
userId Int
@@unique([hashedToken, type])
}
// NOTE: It's highly recommended to use an enum for the token type
// but enums only work in Postgres.
// See: https://blitzjs.com/docs/database-overview#switch-to-postgre-sql
enum TokenType {
RESET_PASSWORD
}
model RequestedProblem {
id Int @id @default(autoincrement())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
user User @relation(fields: [userId], references: [id])
userId Int
minRating Int
maxRating Int
tags String[]
}