Fixed Query error
diff --git a/.gitignore b/.gitignore
index f9d7cba..480c856 100644
--- a/.gitignore
+++ b/.gitignore
@@ -2,6 +2,7 @@
.idea
build/
target/
+**/out
# Ignore Gradle GUI config
gradle-app.setting
diff --git a/service/src/main/java/org/apache/fineract/cn/portfolio/service/internal/repository/CaseRepository.java b/service/src/main/java/org/apache/fineract/cn/portfolio/service/internal/repository/CaseRepository.java
index a036d62..623f4fc 100644
--- a/service/src/main/java/org/apache/fineract/cn/portfolio/service/internal/repository/CaseRepository.java
+++ b/service/src/main/java/org/apache/fineract/cn/portfolio/service/internal/repository/CaseRepository.java
@@ -38,7 +38,7 @@
Page<CaseEntity> findByProductIdentifierAndCurrentStateIn(String productIdentifier, Collection<String> currentStates, Pageable pageRequest);
//TODO: It should be possible to delete the @Query once we've updated to spring-data-release train ingalls.
- @Query("SELECT COUNT(t) > 0 FROM CaseEntity t WHERE t.productIdentifier = :productIdentifier")
+ @Query("SELECT CASE WHEN COUNT(t) > 0 THEN true ELSE false END FROM CaseEntity t WHERE t.productIdentifier = :productIdentifier")
boolean existsByProductIdentifier(@Param("productIdentifier") String productIdentifier);
Stream<CaseEntity> findByCurrentStateIn(Collection<String> currentStates);
