public interface DeviceRepository extends org.springframework.data.repository.PagingAndSortingRepository<Device,java.util.UUID>
Modifier and Type | Method and Description |
---|---|
<T> java.lang.Iterable<T> |
findAllProjectedBy(java.lang.Class<T> type) |
java.lang.Iterable<DeviceView> |
findByDeploymentStatus(boolean deploymentStatus) |
<T> java.lang.Iterable<T> findAllProjectedBy(java.lang.Class<T> type)
@Query(value="select d from Device d left join MonitoredArea ma on d = ma.device group by d having coalesce(max(cast(ma.active as int)), 0) = cast(?1 as int)") java.lang.Iterable<DeviceView> findByDeploymentStatus(boolean deploymentStatus)