I want to implement a recentOrders function in my spring-data app. So for a given customer I want to retrieve the last 5 orders the customer has everytime. But have a separate field that is the entire orders list that I can fetch as needed.

I want to implement a recentOrders function in my spring-data app. So for a given customer I want to retrieve the last 5 orders the customer has everytime. But have a separate field that is the entire orders list that I can fetch as needed.

I am trying to use interface based projections in my spring-data-jpa repositories. I am stuck on trying to understand this behaviour.

I’m using spring boot and spring data jpa 2.7 version for developing our service.
I would like to add every jpa query method when jpa makes sql query without any annotation.

I have the following 2 classes:

I hope you are fine and doing well. At this time I’m developing my RESTful API web service application. I use h2 console temporary db storage and works well.