Submodule 2 · Search & Data Filtering — Concluding Module (Black · Interactive · Compact)

Submodule 2: Search & Data Filtering — Conclusion recap + interactive

This closing module cements core skills: derived queries, JPQL, Specifications, and Pageable. Use the widgets to prove mastery, then export your checklist.

Learning Recap

What this shows: A compact summary of the main techniques you practiced, grouped by topic.

Derived Queries

Spring Data

Equality

findByLocation(String)

Multi-field

findByLocationAndIndustry(..)

Compare

findByExperienceGreaterThan(..)

Like

findByFirstNameContaining(..)

Order/Limit

findTop10ByOrderByExperienceDesc()

JPQL & Native

@Query

Filter

@Query("c.size > :min")

Join

JOIN c.skills s

Projection

SELECT new DTO(...)

Native

nativeQuery = true

Specs & Pageable

Advanced

Specs Chain

where(a).and(b).or(c)

Optional

return null; to skip unused filters

Page

findAll(Pageable)

Sort

PageRequest.of(p,s,Sort)

Final Query Builder

What this shows: A JPQL query and a matching Specification chain assembled from your criteria.

Filter by Location Filter by Industry TechFinanceHealthcareEducation Require Skill Min Experience Any of multiple skills

JPQL

SELECT u FROM User u

Specifications

Specification.where(null)

Pagination Lab

What this shows: Which records appear for the chosen page/size/sort.

page size sort (field,asc|desc)

No results yet…

Capstone Scenario Checker

What this shows: Recommended tool(s) for each scenario and why.

Search public users in NYC with Java skill, sort by experience desc, top 20 Companies with any of {Kubernetes, AWS} skill tags and size > 500 Free-text name contains 'son' & experience ≥ 7 (composable filters)

Your pick Derived Query JPQL Specifications Pageable DTO Projection

Select a scenario and approach, then "Check".

Exit Quiz (5 Qs)

What this shows: Instant feedback on key concepts from the module.

Completion Checklist

What this shows: Your self-evaluation and an exportable JSON of your notes and outputs.

I can write derived methods with multi-field + ordering I can write JPQL joins + projections I can chain Specifications with optional params I can paginate & sort with Pageable I can return DTOs for lean responses

Notes (editable)

Your export will appear here…

---

Tip: Keep controllers thin; push composition into a search service. Favor Specs for optional filters, Pageable for sort/limit, and DTOs for lean payloads.

← Previous Lesson Back to Module →

✓ Lesson 2 completed!