Resolving Empty Results with JPA Conventions, Entity Associations, and Query Optimization Techniques

Case Where Clause of JPQL is not Working as Expected