Adding a new choice in Hardware asset function field

janindiadoc_1 · ‎10-04-2023

Two new choices need to be added in the asset function field in alm_hardware table. This field (asset function) is from the Asset table (alm_asset) . Please advise the better option to add the choices

1. Add the new choices to the asset function field in the hardware table. By doing this, the OOB choices will not be visible. Is there any impact to this field during the upgrades if we recreate the OOB options for the child table? Will the future changes in the base table get inherited to the child table?

2. Add the new choices to the asset function field in the asset (alm_asset) table, but the options will be visible to all the child tables.

Peter Bodelier · ‎10-04-2023

Ah, I misunderstood.

Same goes for this actually. Create them in parent, if they are needed in all childs.
Create them in child if they are only needed there.
Only impact during upgrades could be that you won't see new OOTB choices on parent table within the child.

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

View solution in original post

Peter Bodelier · ‎10-04-2023

Hi @janindiadoc_1,

It is fine to do so. It is correct that it creates duplicates in the child.

There is no other impact than creating new choices yourself.

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.

janindiadoc_1 · ‎10-04-2023

Missed to add this point as the parent and child here I am referring are both out of the box tables.

Peter Bodelier · ‎10-04-2023

Still no problem.

After an upgrade, check if there are new choices on the parent, and copy them to the child as well, if needed.

Help others to find a correct solution by marking the appropriate response as accepted solution and helpful.