Copy the state choice value from one table to another table

[Divya K1]

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.

[sahiltelani]

Hi @Ankur Bawiskar 

I am sorry I might have missed the latest script. Yep, thats perfect and should work.

[Ankur Bawiskar]

@sahiltelani 

no worries

[Divya K1 · Accepted solution]

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();

        }