I'm trying to create a criteria to retrieve Rows from 2 tables (UserDetail, Vehicle). A UserDetail has reference to Vehicle. My objective is to retrieve a list of specified field from both Tables, given an UserDetail id. In @Query was easy to do but the client said that this must be coded with criteria with specification and predicate to Join Tables.
My @Query was:
@Repository
public interface UserDao extends CrudRepository<UserDetail, Integer>{
@Query("SELECT ud.userId, ud.userName ,vh.vehicleId, vh.vehicleName "
+ "FROM UserDetail ud LEFT JOIN ud.vehicle vh where ud.vehicleId = vh.vehicleId")
public List<UserVehicleDTO> findAllUserVehicle();
}
Can anyone help me? I Fetch Data Using Specification with predicate as given Query is needed