SpringData @Query + 사양

Question

사양 및 쿼리 연결을 도와 주실 수 있나요? Pageable은 완벽하게 작동하지만 사양에 문제가 있습니다. 검색 매개 변수가 어디에 추가되지 않았습니다.

public interface RakebackRepository extends JpaRepository<Rakeback, Long>,JpaSpecificationExecutor<Rakeback> {

    @Override    
    @Query(value = "SELECT new domain.model.poker.rakeback.Rakeback(ppr.playerId, SUM(ppr.rakeSum), SUM(ppr.fullRakeBackSum), max(ppra.rakeBackBalance), max(ppra.rakebackRank)) FROM Rakeback as ppr LEFT JOIN ppr.Rakeback as ppra on ppra.status = 'active' LEFT JOIN ppra.rakebackRank as rbb on ppra.rakeBackRankId = rbb.id GROUP BY ppr.playerId ")   
    Page<Rakeback> findAll(Specification<Rakeback> specification, Pageable pageable);
    
    }

다음은 로그의 SQL입니다.

select pokerplaye0_.player_id as col_0_0_,  sum(pokerplaye0_.rake_sum) as col_1_0_,  sum(pokerplaye0_.full_rake_back_sum) as col_2_0_,  max(pokerplaye1_.rake_back_balance) as col_3_0_,  max(pokerplaye1_.rake_back_rank_id) as col_4_0_ 
from rakeback.players_rakebacks pokerplaye0_  
left outer join rakeback.players_rakebacks pokerplaye1_ on pokerplaye0_.player_id=pokerplaye1_.player_id and (pokerplaye1_.status='active')  
left outer join rakeback.rakeback_settings pokerrakeb2_ on pokerplaye1_.rake_back_rank_id=pokerrakeb2_.id and (pokerplaye1_.rake_back_rank_id=pokerrakeb2_.id) 
group by pokerplaye0_.player_id 
order by pokerplaye0_.player_id desc limit ?

여기 내 Speec입니다

public class RakebackListSpec {

private final OperatorService operatorService;
private final PlayerService playerService;



public static Specification<Rakeback> byPlayerId(Long id) {
    return (root, query, criteriaBuilder) ->
            criteriaBuilder.equal(root.get("playerId"), id);
}

public static Specification<Rakeback> byOperator(Integer operatorId) {
    return (root, query, criteriaBuilder) ->
            criteriaBuilder.equal(root.get("operatorId"), operatorId);
}

public Specification<Rakeback> getSpec(RakebackListRequestDto request) {

    Specification<Rakeback> spec = Specification.where(byOperator(operatorService.getOperator().getId()));

    if(request.getOpPlayerId() != null){
        CorePlayer player = playerService.getPlayerByOpPlayerId(request.getOpPlayerId());
        spec = spec.and(byPlayerId(player.getId()));
    }


    return spec;
}

Answer 1

@Query와 Specification결합 할 수 없습니다. 자세한 내용은 이 SO 질문 / 답변 을 참조하십시오.