[FIXED] Dynamic where clause in custom query JPA

Issue

How to pass where clause whitout using query dsl or custom repository?

public interface PlTransactionsRepository extends PagingAndSortingRepository<PlTransactions, Integer>, JpaSpecificationExecutor<PlTransactions> {
      @Query(value = "SELECT a FROM PlTransactions :whereClause")
      List<PlTransactions> selectTrxForRecon(@Param("whereClause") Integer whereClause);
}

Solution

For dynamic where queries, you shouldn't use JPQL but Criteria API or the Spring Data JPA JpaSpecificationExecutor

If you implement JpaSpecificationExecutor you'll get find methods where you can pass a Specification. A Specification will form the dynamic where clause.

Please find more information in the documentation: https://docs.spring.io/spring-data/jpa/docs/current/reference/html/#specifications

Answered By - Simon Martinelli
Answer Checked By - Dawn Plyler (JavaFixing Volunteer)