/
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;



Related content

Creating storage containers
Creating storage containers
Read with this
Block/Unblock Container Positions
Block/Unblock Container Positions
More like this
User Management
User Management
Read with this
Auto Container Allocation
Auto Container Allocation
More like this
Managing containers
Managing containers
Read with this
Fixing database constraint errors
Fixing database constraint errors
More like this
Got feedback or spotted a mistake?

Leave a comment at the end of this page or email contact@krishagni.com