Copy the state choice value from one table to another table

Divya K1 · ‎04-21-2025

Hi All,

asmt_assessment_instance.state : State field is choice field with different languages.

requirement is copy the Display value of asmt_assessment_instance.state to asmt_assessment_instance_question. u_assessment_state. The script probably needs to be run to update the values on the records in the asmt_assessment_instance_question table that have the State in non-English. State value should update with only english language choice value.

Divya K1 · ‎05-23-2025

Hi Ankur,

Thanks for helping, the below script worked

when to run filter Conditions -- state changes

Advanced --condition - current.state != previous.state

var questionGR = new GlideRecord('asmt_assessment_instance_question');

questionGR.addQuery('instance', current.sys_id);

questionGR.query();

while (questionGR.next()) {

questionGR.u_assessment_state = current.getValue('state');

questionGR.update();

}

View solution in original post

Ankur Bawiskar · ‎04-21-2025

@Divya K1

please share your actual business requirement and some screenshots.

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Ankur Bawiskar · ‎04-21-2025

@Divya K1

why are you creating custom field on OOTB table?

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Divya K1 · ‎04-21-2025

Hi Ankur,

Current Reqquirement : Currently we have one business rule which the custom BR "Set assessment state on Update" is set to copy the Display value of asmt_assessment_instance.state to asmt_assessment_instance_question. u_assessment_state.

New requirement is :

The assessment state values are displaying in different language choices but the requirement is to update the records with english state value only even though user preferred language is any language. Assessment state value should update only with english language value not with other language. screenshot below

The reason these are showing in different languages is because the custom BR "Set assessment state on Update" is set to copy the Display value of asmt_assessment_instance.state to asmt_assessment_instance_question. u_assessment_state.

The BR needs to be fixed and then a script probably needs to be run to update the values on the records in the asmt_assessment_instance_question table that have the State in non-English."

Ankur Bawiskar · ‎04-21-2025

@Divya K1

share your BR script and BR config screenshots

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader