Review my code: Accessing MRVS vis record producer script

[Dash2]

Hi community,

I am trying to pull the list of assets in an MRVS and update them via a record producer. Below is my current code which isn't working at the moment, any idea why?

var multiModelVar = JSON.parse(producer.mdf_sets);
if (multiModelVar.length > 0) {
    for (var i = 0; i < multiModelVar.length; i++) {
        var ast = new GlideRecord('alm_asset');
        ast.addQuery('serial_number', multiModelVar[i].serial_number);
        ast.query();
        while (ast.next()) {
            ast.install_status = 1;
            ast.comments = "TESTING THIS RECORD PRODUCER";
            ast.update();
        }
    }
}

[James Chun]

Hi @Dash2,

Try the following:

var multiModelVar = producer.mdf_sets;
for (var i = 0; i < multiModelVar.getRowCount(); i++) {
    var ast = new GlideRecord('alm_asset');
    var rowObj = multiModelVar.getRow(i);

    ast.addQuery('serial_number', rowObj.serial_number);
    ast.query();

    while (ast.next()) {
        ast.install_status = 1;
        ast.comments = "TESTING THIS RECORD PRODUCER";
        ast.update();
    }

}

Cheers