Got feedback or spotted a mistake?

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

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Next »

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 public id of dropdowns.

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";
  • No labels