Spring Boot App Product-Search Bug Fix

Hello,

I can help investigate the product-search category filtering issue in your Spring Boot application.

I will reproduce the incorrect results, inspect the relevant JPQL query, CriteriaBuilder predicates, and entity joins, and identify the root cause of the category filter failure.

My approach will be to:

- Correct the category filtering logic without changing existing pagination or sorting behaviour.
- Verify that results contain only products belonging to the requested category, including cases where no products match.
- Add a focused regression test using JUnit and Spring Test.
- Document the root cause and the correction.

I will first review the repository and reproduce the issue before confirming the final fix and delivery estimate.

**Estimated turnaround:** 1–2 days after reviewing the code and setup.

**Estimated budget:** $15–$30 USD, subject to the complexity of the issue and the existing test setup.

I would be happy to review the repository and discuss the exact scope before proceeding.

Thank you.