There are several drop-downs in my current application. We need an Admin sc

phanibabuk over 8 years ago

There are several drop-downs in my current application.
We need an Admin screen to add/modify/delete the values in all these drop-downs.

Allowing an admin to add new values to a drop-down is not a problem.

I’m wondering if the admin wants to modify/delete values within existing drop-downs.

1. What would happen if an Admin tries to delete a value within a drop-down and the current instances in PROD are using that value.
2. What would happen if an Admin tries to modify a value within a drop-down and the current instances in PROD are using that value.

I wanted to understand if the old instances work?

How can this be handled.

I need inputs around this.

Discussion posts and replies are publicly visible

Parents

0 ChristineH
Certified Lead Developer
over 8 years ago

Generally, I have drop downs (or lookup data) stored in a DB table (i.e. contract_types_lkup) instead of constants.
That table would have CTID (PK - Sequence), ContractName, ContractNameDesc, Active (Boolean)
The admin user would be able to start a process to manage data. They would pick this table. Then, execute a queryrule to get the data from this table. Allow them to edit name, desc, and flag (via an editable grid) and add new rows. Finally, write the CDT to the datastore.

Then in process, where there is a dropdown to select values. Create a queryrule against the table where active is True. That will allow your users to only select active values at that time.

Is that what you are looking for? Hope that makes sense.
Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ChristineH
Certified Lead Developer
over 8 years ago

Generally, I have drop downs (or lookup data) stored in a DB table (i.e. contract_types_lkup) instead of constants.
That table would have CTID (PK - Sequence), ContractName, ContractNameDesc, Active (Boolean)
The admin user would be able to start a process to manage data. They would pick this table. Then, execute a queryrule to get the data from this table. Allow them to edit name, desc, and flag (via an editable grid) and add new rows. Finally, write the CDT to the datastore.

Then in process, where there is a dropdown to select values. Create a queryrule against the table where active is True. That will allow your users to only select active values at that time.

Is that what you are looking for? Hope that makes sense.
Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data