Need to update all child fields when i updated in parent field in cmdb

darling · ‎05-15-2017

Hi,

Any one help on below the requirement

I have created a field called "Brands Supported"on "Business Service" Table.When ever user updated "brand supported" field on parent table the same value has to update on "child table" field.If user want to update any value in child field should not allow only if the parent field value is empty then only has to allow the user to update the value in child field.

Thanks,

Lakshmi

snehabinani26 · ‎05-15-2017

Hi Dasetty,

You can achieve this by glideRecord to cmdb_rel_ci table where parent is the current business service and fetch all the child records and update the same.

Scenario 2 : If user want to update any value in child field should not allow only if the parent field value is empty then only has to allow the user to update the value in child field.

For this write a before update Business rule to check the parent Business service value and if this empty allow action otherwise current.setAbortAction(true);

Let me know in case you require more info.

View solution in original post

snehabinani26 · ‎05-15-2017

If your question is answered , please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.