:wave: is there a way to add a nonstandard filter ...
# orm-help
h
👋 is there a way to add a nonstandard filter to a
findMany
query, besides just using a raw query for the entire thing? Specifically looking to filter a date column by a computed value, query would look like:
Copy code
where "startDatetime" - interval '1 minute' * "duration" > current_timestamp
r
Hey @Hari Demirev 👋 As
interval
and comparing fields of the column is not directly supported, you would need to stick to a raw query in this case unfortunately.
👍 1