Index: ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java =================================================================== diff -u -r30048 -r30049 --- ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 30048) +++ ssts-tousse/src/main/java/com/forgon/disinfectsystem/tousse/toussedefinition/service/TousseInstanceManagerImpl.java (.../TousseInstanceManagerImpl.java) (revision 30049) @@ -8579,12 +8579,12 @@ + "where tousseFixedBarcode=0 %s " + "and td.name='%s' " //+ "and comboTousseInstanceId is null " - + "and (ti.status='%s' or ti.status='%s') ", + + "and (ti.status='%s' or ti.status='%s' or ti.status='%s') ", TousseInstance.class.getSimpleName(), TousseDefinition.class.getSimpleName(), BarcodeDevice.class.getSimpleName(), wareHouseIdSql, - tousseName, TousseInstance.STATUS_STERILED, TousseInstance.STATUS_DISINFECTED); + tousseName, TousseInstance.STATUS_STERILED, TousseInstance.STATUS_DISINFECTED, TousseInstance.STATUS_SHIPPED); }else{ sql = String.format("select ti.id,ti.signedDate,ti.signedUser,bd.barcode,ti.validUntil, ti.invoiceSender, ti.invoiceSendTime, ti.depart " + "from %s ti "