How can a List of Containers be used to Dispose of all the Containers at once?
Answers1
MG
MG2023-06-20Best 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.
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.