studio icon indicating copy to clipboard operation
studio copied to clipboard

isNotNull filter not working

Open SimonBerens opened this issue 1 year ago • 0 comments

In my local prisma studio, when I try to filter a field by isNotNull the filtering does not work image

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.

  1. Prisma version (prisma -v or npx 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
  1. Logs from Developer Tools Console or Command line, if any:

  1. Does the issue persist even after updating to the latest prisma CLI dev version? (npm i -D prisma@dev) Yes

  2. 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[]
}

SimonBerens avatar Feb 27 '23 04:02 SimonBerens