Java Spring Boot - JPA - Hibernate - H2 - Paging with Filtering and Sorting

In this video we will learn how to implement paging, sorting and filtering for our entity using Criteria API. Our technological stack is Java Spring Boot, JPA, Hibernate and H2 database engine. We will deep dive into Criteria API so we will work with things like EntityManager, CriteriaBuilder and CriteriaQuery. We will learn how to create regular query to retrieve information about entity and also how to implement count query. Everything easly explained step by step.

Follow //CodefForgeYT on:

[charcequence]

I solve my problem for 4min, thanks to video!

[regenschirm]

thank you so much, you helped me understand this theme

[sukanyamondal]

great tutorial, can you make a video about joins and range (like date between?) your way of teaching is very easy to wrap our heads around

[joaquinolmedovillodres]

Hello, thank you for the tutorial. I'm trying to add a Date to the predicate this way and it's not working, should be any difference?

[mohamedalivip]

Thank you very much
Can you explain if i want to make query with joined table using criteria builder

[arsensargsyan]

Thanks , how use like.root.get("enumName") enum type from string parameter?

[srinathselvam]

Hi, incase of custom count query based on multiple table joins.. how to get total count records for pagination?

[niladrisekharnath]

Hey thanks for this great video can you please provide a link of the video where we can get the swagger ui and work with our endpoints Like how to set it up and use that ?

[kanismit]

Hi, nice tutorial but what about joins ? for example i need to filter by fields that in other table

[falseys]

Nice Tutorial, Thank you! One question, In real time how do we pass two different objects EmployeeSearchCriteria and Employee Page to get mapping method in the controller, For Example when testing it in post man

[rosssihovsk]

Hey, i saw in comments idea about filering information in range(date between). is it worth waiting for the video or have you changed your mind about making it?

[Khantia]

Why aren't you using @Autowired tho? In the project I'm working on, the "regular" repository is already using this annotation (within the service... and the service is also autowired in the controller) and now I don't know how to adjust your code in order to make them both work together.

[BlendSkMix]

If field has null values, how to make it return value zero??
Using criteria builder.
In sql i know we use IFNULL(NULL, 0)

[pratikghotekar]

Hello, How we can use operators like <.>, ! in as query params in the URL. How can i extract and use in the criteria builder

[averagedev]

Could we just use Pagable interface from spring boot itseflf

[sunnyisonvacation]

nice . But im unable to find github code for this tutorial ?

[Runnable]

Thanks for the work but I think this video needs to be updated because of this problem "Error Message: Already registered a copy: SqmBasicValuedSimplePath". I'm using java 21.

[BabaykaMoscow]

Is it possible to sort by multiple fields?

[artemryvkin]

nice video, but it will be good to get more explanation about used objects and methods... Because most of the video - just retelling or spelling the code you write

[WaqarAhmad-ikdt]

Thank you so much, How we can filter with nested objects
product {
title;
Detail detail;
}
Detail {
description;
}