Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java =================================================================== diff -u -r37777 -r37779 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 37777) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 37779) @@ -1979,7 +1979,7 @@ + " from tousseinstance t" + sqlJoin_UrgentLevel + " join barcodedevice b on b.id=t.id " + " join TousseDefinition td on td.id=t.tousseDefinition_id " - + "where td.tousseType in ('"+TousseDefinition.PACKAGE_TYPE_CUSTOM+"') and t.reviewBasket_id " + + "where td.tousseType ='"+TousseDefinition.PACKAGE_TYPE_CUSTOM+"' and t.reviewBasket_id " + reviewedBasketSql + " and t.orgUnitCoding='"+currentOrgUnitCode+"' " + " and t.status <> '" + TousseInstance.STATUS_DISCARD + "'" @@ -2024,7 +2024,7 @@ + sqlSelect_SpellingSql + " from tousseinstance t " + sqlJoin_UrgentLevel + " join barcodedevice b on b.id=t.id join TousseDefinition td on td.id=t.tousseDefinition_id " - + " where td.tousseType in ('"+TousseDefinition.PACKAGE_TYPE_CUSTOM+"') and t.reviewBasket_id " + + " where td.tousseType ='"+TousseDefinition.PACKAGE_TYPE_CUSTOM+"' and t.reviewBasket_id " + reviewedBasketSql + " and t.orgUnitCoding='"+currentOrgUnitCode+"' " + " and t.status <> '" + TousseInstance.STATUS_DISCARD + "'"