How to update system set (using script)

[Takumi_]

Hi All.

I'm trying to update system set (sc_item_option)

I want to know that if you know something.

--------------------------------------------------

sample

-------------------------------------------------

// RITMNumber -> RITM + some number
// query table sc_item_option_mtom, get sc_item_option
var mtomGR = new GlideRecord('sc_item_option_mtom');
mtomGR.query();
var targetItemOptionSysID;
while (mtomGR.next()) {
if (mtomGR.getDisplayValue('request_item') == RITMNumber) {
targetItemOptionSysID = mtomGR.getValue('sc_item_option');
break;
}
}
// query table sc_item_option
var itemOptionGR = new GlideRecord('sc_item_option');
itemOptionGR.addQuery('sys_id', targetItemOptionSysID);
itemOptionGR.query();
while(itemOptionGR.next()){
if(itemOptionGR.getValue(value) == 'thisIsTarget'){
itemOptionGR.setValue('value', 'testValue');
itemOptionGR.update();
}
}

-------------------------------------------------

I'm not good at English.

You don't know what I said, Please ask me.

[Takumi_]

var RITMNumber = 'RITM0010001'; // -> RITM + some number
// query table sc_item_option_mtom, get sc_item_option
var mtomGR = new GlideRecord('sc_item_option_mtom');
//mtomGR.addEncodedQuery("request_item.numberSTARTSWITH"+RITMNumber); // Always add a filter to out the unwanted response.
mtomGR.query();
var targetItemOptionSysID;
while (mtomGR.next()) {
if (mtomGR.getDisplayValue('request_item') == RITMNumber) {
targetItemOptionSysID = mtomGR.getValue('sc_item_option');
updateOptionValue(targetItemOptionSysID);
}
}

function updateOptionValue(sysid) {
// query table sc_item_option
var itemOptionGR = new GlideRecord('sc_item_option');
itemOptionGR.addQuery('sys_id', sysid);
itemOptionGR.addQuery('item_option_new', 'hostname_1'); // hostname_1 is question.
itemOptionGR.query();
while (itemOptionGR.next()) {
if (itemOptionGR.getValue('value') == 'testValue') {
itemOptionGR.setValue('value', 'test');
itemOptionGR.update();
}
}
}

[Abhit]

Just small change on itemOptionGR.addQuery('item_option_new', 'hostname_1');

var RITMNumber = 'RITM0010001'; // -> RITM + some number
// query table sc_item_option_mtom, get sc_item_option
var mtomGR = new GlideRecord('sc_item_option_mtom');
//mtomGR.addEncodedQuery("request_item.numberSTARTSWITH"+RITMNumber); // Always add a filter to out the unwanted response.
mtomGR.query();
var targetItemOptionSysID;
while (mtomGR.next()) {
    if (mtomGR.getDisplayValue('request_item') == RITMNumber) {
        targetItemOptionSysID = mtomGR.getValue('sc_item_option');
        updateOptionValue(targetItemOptionSysID);
    }
}

function updateOptionValue(sysid) {
    // query table sc_item_option
    var itemOptionGR = new GlideRecord('sc_item_option');
    itemOptionGR.addQuery('sys_id', sysid);
    itemOptionGR.addQuery('item_option_new.name', 'hostname_1'); // hostname_1 is question.
    itemOptionGR.query();
    while (itemOptionGR.next()) {
        if (itemOptionGR.getValue('value') == 'test123') {
            itemOptionGR.setValue('value', 'test1234');
            itemOptionGR.update();
        }
    }
}