Change/Update a field's value(name) in the records from a particular custom table across instances

[Keerthan S]

Below is the function I used in my script.

I need to replace the display names for LoBs from 'AJ' to 'ABD' and from 'BS' to 'HM' from one custom

_getLob: function(source) {
var arrayutil = new global.ArrayUtil();
//list of LoBs with their sources
var a = ['agaf'];
var b = ['mas', 'shshh'];
var c = ['8s', 'mi', 'mnt'];
var dc = ["ks"];
//Array of LoBs with their names
var arrayOfLobs = [['AJ', a], ['BS', b], ['CF', c], ['CM', dc]];

I need to replace the display names for LoBs from 'AJ' to 'ABD' and from 'BS' to 'HM' from one custom table:"u_per_source_example"

The record insertion to the table will be on a daily basis.
LoB names needs to be updated for all the previous LoB records and also for future insertion of records in the 'u_per_source_example' table.

note: in the code we can just replace it and thinking it might work from tomorrow records as the new insertions will be done.

But I need to update previous records in that table for one particular field 'LoB'.
(from  'AJ' to 'ABD', 
'AJ' LoB has nearly 6000 records in lower instance, around 8000 records in higher instance)
Can we do this through fix script?

Can anyone give me exact procedure to update previous records and how I can implement across different instances

[jcmings]

So are you trying to update the records or arrays within the records (i.e. list collectors)? It would be possible using a fix script (you'd have to run this in both environments). I would be cautious of records that contain "AJ" or "BS" that are not explicitly the records you are looking for (for instance, you'll need to ensure you don't capture records like "AJB" or "PAJ").

[Keerthan S]

The ask is to find a solution to change the LoB names, (from AJ to ABD). 

I will change it in script so that records from tomorrow will have ABD.

(FROM var arrayOfLobs = [['AJ', a],
TO var arrayOfLobs = [['ABD', a], )
But to update the past records which had LoB field name as AJ also need to be updated to LoB, so to update those records to ABD, should we use fix script?

OR is there any other best method to fix a longterm solution. If we need to change the LoB names regularly.

[jcmings]

Yes, I believe you can use a fix script to update the previous records.

[Keerthan S]

can we update around 80K records for a total of 3 LoBs name change at a time in a single script includes and if yes on PROD instance as well. (potential impact on performance to tackle)