/
How to reset restrictions of all storage containers?
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com
How to reset restrictions of all storage containers?
Restrictions can be reset in 2 steps by directly executing the SQLs against the target database as explained below:
Step 1: Clear all restrictions
delete from os_stor_cont_spec_classes; delete from os_stor_cont_spec_types; delete from os_stor_container_cps; delete from os_stor_cont_comp_spec_classes; delete from os_stor_cont_comp_spec_types; delete from os_stor_container_comp_cps; commit;
Step 2: Add default restrictions to allow all kinds of specimens
insert into os_stor_cont_comp_spec_classes(storage_container_id, specimen_class) select c.identifier as storage_container_id, t.spmn_class as specimen_class from os_storage_containers c, ( select 'Cell' as spmn_class from dual union select 'Fluid' from dual union select 'Molecular' from dual union select 'Tissue' from dual ) t where c.activity_status != 'Disabled'; commit;
, multiple selections available,
Related content
Managing containers
Managing containers
Read with this
Creating storage containers
Creating storage containers
Read with this
Resizing Containers
Resizing Containers
More like this
Container Utilisation Report
Container Utilisation Report
More like this
Auto Container Allocation
Auto Container Allocation
More like this
Containers CSVs
Containers CSVs
More like this
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com