With the new JSON filtering feature that's part of...
# orm-help
m
With the new JSON filtering feature that's part of
2.23.0
- is there a way to cast the value of a "path"? For example our JSON in Postgres has string values for all paths - but we want to say convert that on the fly to a Postgres int to do <, <=, > ect comparisons? To solve this we are doing RAW prisma sql, but was wondering if there was features (or features in the future) that could address this.
r
@Michael 👋 Unfortunately not at the moment so you’ll have to stick with a raw query for now. It would be great if you could open a feature request here so that we can look into this 🙂