Hey, I am trying to use the json filtering with nodejs, but it is not giving me back what i expect. I have this json in column

values

{
  "test": 10
}

and i trying to grab it this way:

const entries = await this.prismaClient.accountEntity.findMany({
      where: {
        values: {
          path: ["test"],
          gt: 5,
        },
      },
    });

but it doesn't return anything. I would expect it to return all rows above 5. I have the following preview features:

previewFeatures = ["orderByRelation", "filterJson"]

I have tried to upgrade to version 2.25.0 but still no luck. Please let me know if im doing anything wrong

I’m pretty sure the comparison here being done is a string comparison. If you check for the value

{"test": 9}

it will work fine. I would suggest creating an issue here with the above use case so that we can look into this.

Yes i agree. When i was testing as well it seemed to be doing a string comparison when it shouldn't be.

Awesome! Thanks for opening the issue 🙂