studio icon indicating copy to clipboard operation
studio copied to clipboard

"And" not working with filters

Open hel-lo7 opened this issue 6 months ago • 0 comments

Bug description

The and keyword with filters just doesn't seem to work.

I tried many times to restart the studio, retype true and false, and readd the filters but nothing worked.

How to reproduce

Open a table in the studio and have two filters of boolean values, one true and one false.

Expected behavior

Only rows which match both filters should show.

Prisma information

prisma : 5.17.0 @prisma/client : 5.17.0 Computed binaryTarget : windows Operating System : win32 Architecture : x64 Node.js : v20.9.0 Query Engine (Node-API) : libquery-engine 393aa359c9ad4a4bb28630fb5613f9c281cde053 (at node_modules@prisma\engines\query_engine-windows.dll.node) Schema Engine : schema-engine-cli 393aa359c9ad4a4bb28630fb5613f9c281cde053 (at node_modules@prisma\engines\schema-engine-windows.exe) Schema Wasm : @prisma/prisma-schema-wasm 5.17.0-31.393aa359c9ad4a4bb28630fb5613f9c281cde053 Default Engines Hash : 393aa359c9ad4a4bb28630fb5613f9c281cde053 Studio : 0.502.0 Preview Features : omitApi

Environment & setup

  • OS: Windows 11
  • Browser: Chrome
  • Database: PostgreSQL

Prisma logs

Seems that it is using and but is discarding the first filter.

hel-lo7 avatar Aug 06 '24 01:08 hel-lo7