package ru.vniins.ais.realty.subsystem.hab.repository;
import org.springframework.data.domain.*;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;
import ru.vniins.ais.realty.subsystem.hab.domain.Soldier;
public interface SoldierRepository extends PagingAndSortingRepository<Soldier, Long> {
@Query("select s from Soldier s where not exists (select e from s.employmentAgreements e where e.evictionDate is null)")
Page<Soldier> findWithoutEmploymentAgreement(Pageable pageable);
}