How to fix JPA Postgres Java error using COALESCE
So I have this formula query that joins two table to one table. The query works fine when I use it it pgadmin query tool but once I add it on Formula annotation for JPA/JAVA it throws an error of “ERROR: more than one row returned by a subquery used as an expression”.
How can I use an SQL ‘in’ clause with potentially empty list parameter in Java JPA?
I have a JPA repository interface with the following method: