SI-2280 Fix im Select
diff --git a/gfsBackendService/src/main/java/org/eclipse/openk/gridfailureinformation/repository/FailureInformationRepository.java b/gfsBackendService/src/main/java/org/eclipse/openk/gridfailureinformation/repository/FailureInformationRepository.java index d41068e..2196551 100644 --- a/gfsBackendService/src/main/java/org/eclipse/openk/gridfailureinformation/repository/FailureInformationRepository.java +++ b/gfsBackendService/src/main/java/org/eclipse/openk/gridfailureinformation/repository/FailureInformationRepository.java
@@ -32,7 +32,7 @@ public interface FailureInformationRepository extends PagingAndSortingRepository<TblFailureInformation, Long > { @Query("SELECT a from TblFailureInformation a WHERE a.tblFailureInformationCondensed IS NULL " + - "AND ( (a.refStatusIntern.id NOT IN (:statusClosedId, :statusCancelledId) OR a.failureEndResupplied IS NULL ) OR " + + "AND ( a.refStatusIntern.id NOT IN (:statusClosedId, :statusCancelledId ) OR " + "(a.refStatusIntern.id = :statusClosedId AND a.failureEndResupplied IS NOT NULL AND a.failureEndResupplied >= :dateNowFourWeeksAgo) OR" + "(a.refStatusIntern.id = :statusClosedId AND a.failureEndResupplied IS NULL AND a.modDate >= :dateNowFourWeeksAgo) OR" + "(a.refStatusIntern.id = :statusCancelledId AND a.modDate >= :dateNowFourWeeksAgo) ) ORDER BY a.failureBegin ASC")