Vishal Attarde

Staff Engineer

Posts by Vishal Attarde:

• Implementing dynamic filtering on joined queries using JPA specification and criteria API

  Mar 27, 2023 • Vishal Attarde • Engineering

  Introduction:

  In most web applications, we would have come across a requirement to filter, sort, and paginate the data by joining multiple tables. If you are using Spring JPA then there are multiple ways to retrieve and paginate the data on joined table.

  1. Writing native queries.
  2. Using JPQL query.
  3. Using inbuilt repository methods.

  These options are good for the use case where we will have to construct the query based on a fixed set of conditions/where clauses. We can’t add where clause at runtime using these options.

  Spring JPA also provides the capability to generate dynamic SQL queries with help of Criteria API and Specification. In this article, we will see how we can leverage JPA Criteria query support to build generic specifications which can retrieve rows from joins on multiple tables with sorting and pagination.

  read more