Spring Data JPA -Criteria Queries - The Full Guide

[@BoualiAli]

Join the Micro Services course waiting list and get and get an exclusive *EARLY-BIRD discount* aliboucoding.ck.page/d0f9317e13

[@supun_sandaruwan]

I didn't even heard about criteria queries in spring boot. Thank you so much for sharing knowledge with us, Sir ❤🌻.

[@BoualiAli]

Glad you liked it!

[@4wrk]

Thanks a lot! Your guide helped me to avoid creation of bunch of unnecessary methods within my repo layer :)

[@BoualiAli]

Glad it helped!

[@toufiqulislamimran7911]

Man you are a life saver, till this video I didn't know about this feature of JPA. Thanks a lot man.❤❤

[@BoualiAli]

Happy you liked it! You can also check the SPring Data JPA advanced course on my website aliboucoding.com/courses

[@toufiqulislamimran7911]

@@BoualiAli Thank you so much and Please make video on Unit testing

[@BoualiAli]

@@toufiqulislamimran7911 soon

[@CoolBishop1997]

Jazaka llaho khayran

[@fatemehsalem3850]

Thank you for providing this tutorial, it is so unique

[@BoualiAli]

Happy you liked it!

[@spring8355]

Thank you for your kind explanation, keep going ❤❤❤. Please, I would like to know what is the best practice for handling exception : extending "Exception" or extending "RuntimeException"

[@BoualiAli]

You can check the exception handling video

[@yashkevich]

In the first case, the request will look like: select * from employee where (last_name = LIKE '%:lastName%' OR first_name LIKE '%:firstName%') AND first_name LIKE '%:email%') That is, the OR predicates will be in parentheses (1 OR 2) AND 3, since they are in a separate predicate

[@soumikdash2866]

Thank you very much sir really appreciate your effort.

[@toufiklaggoune5972]

Always the best. Keep going bro.

[@BoualiAli]

Thanks a lot. I will

[@pqan112]

Thanks so much teacher, I'm a newbie Springboot. I don't know how to create complete API with relationship between tables. Other tutorial videos just teach me how to create API based on an entity. I hope you can do a video about my problems, thanks

[@BoualiAli]

Enjoy this aliboucoding.com/p/first-hands-on-spring-boot-framework

[@pqan112]

@@BoualiAli Thank you so much teacher

[@atefjlassi193]

Great, Thank you Bouali

[@BoualiAli]

Thank you

[@rihabbensoula1016]

Great job ,keep going

[@BoualiAli]

Thank youuuuu

[@123cheke]

great video. Quick question, what about if email has underscore characters(_) ?

[@Teze-m8b]

Excellent tutorial

[@geethikathota9063]

Very helpful. Thank you so much.

[@BoualiAli]

Glad it was helpful!

[@kyrylochornobryvets3385]

Hmm. Full Guide without joins and join fetch?! But you gave good approach. Thanks. It will be great if you create really full guide for Criteria Queries with joins and fetch joins and some queries which we don't know. 👍

[@ShrivastavaMohit07]

Great explanation

[@BoualiAli]

Glad it was helpful!

[@ruff7209]

Nice tutorial, thx man!

[@BoualiAli]

Happy you enjoyed it

[@attabou100]

Exactly ; I repeated the video , and you explained very well when criteria is used ; thnaks a lot dear Teacher

[@BoualiAli]

My pleasure 😇

[@samarthkamble7270]

Thanks a lot man❤

[@BoualiAli]

You're welcome!

[@elkhanismayilov]

Thank you for this tutorial but I have a question for that topic. How we can search to date range with criteria query. Would you explain or refer for me???

[@AnvarbekTurdaliyev]

thank you very much

[@BoualiAli]

My pleasure!

[@imranmomin4571]

@BoualiAli Can you make a video on search on multiple table using criteria query ?

[@nailiridha7179]

tres bien bravo

[@BoualiAli]

Thank you

[@arturszmer3336]

Hey! Your tutorials are great but please do something with sound on introduction :) Just take mikrofon closer to you, if you want to hide your microfon you could place them under the view but close to you. Another way is bring more staff to you room to make reverb much smaller ;) If you need any advice about sound you can let me know.

[@BoualiAli]

Thank you so much for the nice feedback. I upgraded my setup for better quality. Yes I would like to discuss more with you.please reach out on discord

[@hoangkim6246]

Thank you for your video. Can you tell me how to join multiple tables where the returned result list is a collection of attributes from those tables.I'm sorry that my English is very bad. I hope you will understand

[@BoualiAli]

User Projection

[@larsmichael6242]

Nice video. Just having some trouble with querying nested objects in my entities. I'm using the @Embedded / @Embeddable annotations, but am not quite sure how to format the json data in my request body so that Spring understands.

[@BoualiAli]

Can you share more details? Maybe in our discord server, sharing will be easier and get faster feedback

[@ankukoul07]

Nice..What if there are multiple filter conditions like for 20 fields..?

[@BoualiAli]

Same way

[@attabou100]

Thanks a lot

[@BoualiAli]

Welcome

[@luwamabraham4338]

Thank You

[@BoualiAli]

My pleasure

[@codewithtee]

How can make the list be a custom Response, e.g EmplyeeResponseDto and also how do I query relation of Employee (e.g depeartment)

[@Utub-qc2cz]

Question: Is there anyway to access Join tables using criteria API ?

[@daoookhanhuyenn]

If I want to join a table in Criteria, how should I do it?

[@smb6311]

Merci beaucoup pour le tuto Sensei! ça aurait été encore plus plus cool illustré avec un pageable.

[@BoualiAli]

Noted

[@norulshahlamjohn1140]

i believe this all can be greatly simplified by using Derived Query Methods in Spring Data JPA Repositories right sir?

[@BoualiAli]

It is possible but you will need to write a complex query for it to handle all the fields. Criteria query is more flexible in that direction

[@GianfrancoTerrazzano]

Hi! Thanks for the tutorial, it was great. There is a github where I can find the source code?

[@BoualiAli]

In the description

[@manojv2893]

This syntax doesn't work with Hibernate 6 as we cannot use the same predicate more then once. Can you please re-record for Hibernate 6?

[@gokulvarshan1114]

can you help me with a problem please... i Need to filter a single string of a id from the list of string of id which is inthe database using this method you said can u tell me please

[@BoualiAli]

Can you give an example? I didn’t get what you mean

[@gokulvarshan1114]

@@BoualiAli how to search a single string in list of string

[@ahmedabdoz]

I am sorry but you said we are using that to avoid using if/else ,in the second example it ends up doing this , you have an if check for every search criteria

[@BoualiAli]

there is a difference between if..else to compose a query and if..else for null check

[@saiprasanthmattupalli4611]

How do we join multiple tables in criteria query ?

[@BoualiAli]

I will make a video on that soon

[@mayureshkumar3717]

didn't understood the last part of using toArray and passing it to the or method

[@ngavv7095]

what spring-data-jpa-pro-class whait project in github want to do,it's about easier using JPA?Looking forward your answer,thacher

[@BoualiAli]

This is the spring data jpa pro class course coming really soon. Join aliboucoding.com and you receive an email when the course is released

[@ngavv7095]

@@BoualiAli tks

[@attabou100]

In your opinion, is there an advantage of always using "Criteria Queries" despite it being too long and complicated ?

[@BoualiAli]

Always, I would say no I already explained the use case of criteria queries

[@mona9741]

do you have the code for this project in github, cause I can't find it ps: great vid

[@BoualiAli]

Sorry, no

[@rohan1618]

Do you have junit for this code?

[@BoualiAli]

Unfortunately not

[@rohan1618]

@@BoualiAli how to write junit for this any book anywhere

[@niladrisekharnath]

I have a question why use Predicate[0] ?

[@BoualiAli]

Foo[] array = list.toArray(new Foo[0]);

[@muhendis_]

there are lots of thing what ı dont know. I have to learn these descriptions 🙁

[@BoualiAli]

Yes, the learning path is quite long but nothing is impossible

[@elkhanismayilov]

why yo doesn't suggest us dynamic query like any repo @Query ?

[@BoualiAli]

Will add it in the next video

[@piseyheng2564]

Could you provide source code link please?

[@BoualiAli]

I will try to find it and update the description

[@stefumies]

Quite a bit of information here, yet very disappointing that you are choosing to become far more involved than the last lessons. If you are choosing to show the more advanced areas of JPA I think more specific explanations are required. There is far too much for a beginner to consume, and you merely are instructing watchers to follow along with what you do, but failing to educate them on the what and why. For me, criteria queries are a rather less-than-basic-feature of JPA and, in this current example, highly unnecessary and over complicate things substantially. It almost feels as if you have skipped several more introductory lessons to JPA queries and started right in at the deep end. You do some great material, but many of your lessons are rather to off the flow for beginners. For me, I think most of your content is fantastic, even as an old and seasoned developer I always get something out of them,. but I feel here you have lost direction somewhat.

[@BoualiAli]

Hi, Thank you for the feedback. All the answers for your questions are in the spring data jpa complete lesson. It is better to enable the notifications to get all the recent videos.