Updating dropdown values

Via user interface - Enterprise users

Refer to Dropdown Manager

Via database - Community users

  1. Connect to the database
  2. Insert new values in table catissue_permissible_values.
  3. Identifier: is auto-generated, do not set any value to this.
  4. Public ID: Refer catissue_cde table to know the public id of the dropdowns.

SQL to add new permissible value

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

SQL to delete the permissible value

  1. Delete a permissible value from 'Gender'
    delete from catissue_permissible_value where value="Male" and public_id="gender"
  2.  Delete permissible value from specimen type
    delete from catissue_permissible_value where identifier=<id>
    Note- By using select query get identifer of the deleting value.
    select identifier from catissue_permissible_value where value="Buffy Coat" and public_id="specimen_type";