Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Via user interface - Enterprise users

...

Adding new permissible values

Examples:

  1. Add new value in 'Gender'

    insert into catissue_permissible_value(value, public_id) values('Male', 'gender');

  2. Add new value in "Specimen Type" under "Fluid"
    insert into catissue_permissible_value(value, public_id, parent_identifier) 
    select 
      'Buffy Coat', 'specimen_type', identifier 
    from 
      catissue_permissible_value 
    where 
      value="Fluid" and public_id="specimen_type";