Javascript

[developersn]

One variable - business_unit(Choice- X,Y,Z,A,B,C)

Another variable- impacted_business_unit (reference to business_unit variable)

Requirement : To map the impacted_business_value for all the records(1000s) with below mentioned conditions :

1. All the records with choice X & Y Selected in Impacted business unit, it should be changed to Choice A.

2. All the records with choice Z & C selected in Impacted business unit, it should be changed to Choice B.

Any help on this would be highly appreciated.

[Vishal Birajdar]

Hi @developersn 

You can write a Fix script to update the records :

/*1. Glide record on your table*/
var gr = new GlideRecord('your_table_name');
gr.addEncodedQuery('business_unit=X^ORbusiness_unit=Y' );  // query with business unit
gr.query();

while(gr.next()){
/*2. Update the record with desired business unit*/
gr.your_field_name = 'A';
gr.update();
}

//You can use same logic for other business unit

Hope this helps...!!!

[Anand Kumar P]

Hi @developersn ,
Write fix script

var incidentRecord = new GlideRecord("table");
incidentRecord.query();
while (incidentRecord.next()) {
  var businessUnit = incidentRecord.business_unit;
if ((businessUnit == 'X' || businessUnit == 'Y')  {
    incidentRecord.impacted_business_unit = 'A';
  } else if ((businessUnit == 'Z' || businessUnit == 'C')  {
    incidentRecord.impacted_business_unit = 'B';
  }
  incidentRecord.update();
}

Thanks,

Anand