How can a List of CISPro Containers be used to Dispose of all the Containers at once?

How can a List of Containers be used to Dispose of all the Containers at once?

Answers 1
MG
MG 2023-06-20 Best Answer

It is possible to dispose in bulk from Multi-Edit. The container list can be entered via a Report which does not open in a new window, for example:

Report SQL:

with
    b as --barcodes
     (select distinct trim(regexp_substr('{Barcodes}','[^,]+', 1,level) ) as str
      from dual
      connect by regexp_substr('{Barcodes}', '[^,]+', 1, level) is not null )
select
    nodeid, 1030 as nodetypeid, barcode, material, owner, location
from
    container
where
    disposed = 'N'
    and obsolete = 0
    and barcode in (select str from b)


Report Run Instructions:

This report can be used to search for a list of non-disposed containers. This list should be entered in the Barcodes filter as a comma delimited list, for example: C000123,C000246,C000369

Grid returned containers can be disposed in bulk by selecting the containers to dispose, clicking Edit Selected and then clicking the Dispose this Container button in the displayed container.