/
Updating dropdown values
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com
Updating dropdown values
Via user interface - Enterprise users
Refer to Dropdown Manager
Via database - Community users
- Connect to the database
- Insert new values in table catissue_permissible_values.
- Identifier: is auto-generated, do not set any value to this.
- Public ID: Refer catissue_cde table to know the public id of the dropdowns.
SQL to add new permissible value
Examples:
- Add new value in 'Gender'
insert into catissue_permissible_value(value, public_id) values('Male', 'gender'); - 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
- Delete a permissible value from 'Gender'
delete from catissue_permissible_value where value="Male" and public_id="gender" - 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";
, multiple selections available,
Related content
Dropdown Manager
Dropdown Manager
More like this
Custom Field with 100+ Dropdown Values
Custom Field with 100+ Dropdown Values
More like this
How to resolve permissible-values.xml changeset failed.
How to resolve permissible-values.xml changeset failed.
More like this
How to remove default value set for the custom form field?
How to remove default value set for the custom form field?
More like this
How to make PV (permissible value) field multi-select?
How to make PV (permissible value) field multi-select?
More like this
Set default value for child based on value of parent/primary specimen
Set default value for child based on value of parent/primary specimen
More like this
Got feedback or spotted a mistake?
Leave a comment at the end of this page or email contact@krishagni.com