Spring Data JPA – Is it possible to sort on a calculated property?

by

The problem is that Spring Data’s PageRequest sort is done on the database layer by forming the ORDER BY clause.

You could create a @Formula column, e.g.

@Entity
public class Game {
...
     // rewrite your logic here in HQL
     @Formula("case when startTime >= endTime then 'FINISHED' ... end")
     private String status;

Then it will be possible to use the new column in sort order as everything you write in the formula will be passed to ORDER BY clause.

More Related Contents:

  1. Dynamic spring data jpa repository query with arbitrary AND clauses
  2. setMaxResults for Spring-Data-JPA annotation?
  3. Using generics in Spring Data JPA repositories
  4. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  5. Handling soft-deletes with Spring JPA
  6. Filtering database rows with spring-data-jpa and spring-mvc
  7. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  8. Spring-Data FETCH JOIN with Paging is not working
  9. Why use returned instance after save() on Spring Data JPA Repository?
  10. How to use @Transactional with Spring Data?
  11. Spring Data JPA: query ManyToMany
  12. Spring Data JPA: Query by Example?
  13. How to store @Query sql in external file for CrudRepository?
  14. Spring Data – Multi-column searches
  15. Spring Data JPA find by embedded object property
  16. Missing CrudRepository#findOne method
  17. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  18. Best way of handling entities inheritance in Spring Data JPA
  19. Spring Data + JPA with multiple datasources but only one set of Repositories
  20. Spring-Data-Jpa Repository – Underscore on Entity Column Name
  21. How to maintain bi-directional relationships with Spring Data REST and JPA?
  22. Implementing custom methods of Spring Data repository and exposing them through REST
  23. How to do a Mongo aggregation query in Spring Data?
  24. Java SE + Spring Data + Hibernate
  25. Filtering data with Spring boot CrudRepository
  26. Use abstract super class as parameter for Spring data repository
  27. Are you supposed to have one repository per table in JPA?
  28. Autowiring fails: Not an managed Type
  29. How to instrument / advice a Spring Data (JPA) repository?
  30. Externalize query in spring boot application

Leave a Comment