prisma / studio

🎙️ The easiest way to explore and manipulate your data in all of your Prisma projects.
https://www.prisma.io/studio
1.87k stars 47 forks source link

Can't filter DateTime field by Null #1061

Open tyteen4a03 opened 1 year ago

tyteen4a03 commented 1 year ago

Bug description

In Prisma Studio, I cannot filter a ?DateTime field by null. It requires me to fill in a value which I obviously don't have.

Screenshot 2022-11-28 at 02 29 47

How to reproduce

  1. Open Prisma Studio
  2. Try to filter a DateTime column by isNull / isNotNull

Expected behavior

No response

Prisma information

prisma                  : 4.6.1
@prisma/client          : 4.6.1
Current platform        : debian-openssl-1.1.x
Query Engine (Node-API) : libquery-engine 694eea289a8462c80264df36757e4fdc129b1b32 (at node_modules/@prisma/engines/libquery_engine-debian-openssl-1.1.x.so.node)
Migration Engine        : migration-engine-cli 694eea289a8462c80264df36757e4fdc129b1b32 (at node_modules/@prisma/engines/migration-engine-debian-openssl-1.1.x)
Introspection Engine    : introspection-core 694eea289a8462c80264df36757e4fdc129b1b32 (at node_modules/@prisma/engines/introspection-engine-debian-openssl-1.1.x)
Format Binary           : prisma-fmt 694eea289a8462c80264df36757e4fdc129b1b32 (at node_modules/@prisma/engines/prisma-fmt-debian-openssl-1.1.x)
Format Wasm             : @prisma/prisma-fmt-wasm 4.6.1-3.694eea289a8462c80264df36757e4fdc129b1b32
Default Engines Hash    : 694eea289a8462c80264df36757e4fdc129b1b32
Studio                  : 0.476.0
Preview Features        : interactiveTransactions, fullTextSearch
Done in 5.48s.

model Club {
  id             Int            @id @default(autoincrement())
  deletedAt      DateTime?
}

Environment & setup

Prisma logs

No response

ashu-shukla commented 1 year ago

Similar error observed with Float? valued columns using SQLite as DB.

Zenoo commented 1 year ago

Can confirm, same issue with the DateTime field. Pretty annoying when working with a deletedAt field ...