Alm_asset cannot access state or substate in a script

[ppicazo1]

In "Scripts - Background" I pasted the code below the dotted line.   I really want to update the substate field but I see when I run the script below it comes up undefined.   Increasing the size of x does not matter.   I tried to do an update based on what Google's AI told me but it did not work.   I even tried a setValue but it did not work or give me an error.   Can anyone help me?

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

var assetUnAssign = new GlideRecord('alm_asset');

assetUnAssign.query();

var x = 0;

while (assetUnAssign.next())

{  

    gs.print(assetUnAssign.substate);

    x++;

    if (x > 8)

        break;

}

[RaghavSh]

Try below:

var assetUnAssign = new GlideRecord('alm_asset');

assetUnAssign.query();

var x = 0;

while (assetUnAssign.next())

{  

    gs.print(assetUnAssign.substatus);

    x++;

    if (x > 8)

        break;

}

 There has to be a <space> between new and GlideRecord() as above.

also there could be the possibility that 8 records this query is picking does not have substate.

[ppicazo1]

There is a space between new and GlideRecord.   I changed the value of x to 1000 and I still received the same results.   Any other suggestions please make it.

[Ajay_Chavan · Accepted solution]

@ppicazo1 - 

Get the substatus choices from sys_choice table- 

var asset = new GlideRecord('sys_choice');
asset.addEncodedQuery('nameSTARTSWITHalm_asset^element=substatus^language=en');
asset.query();
while (asset.next()) {
    
    gs.print("state: " + asset.value);
}

then decide which substatus you want to update then use below script: 

var asset = new GlideRecord('alm_asset');
// Add conditions as needed, e.g.:
// asset.addQuery('state', 'in_use');
asset.setLimit(100); // Safety limit
asset.query();

var count = 0;
while (asset.next()) {
    asset.setValue('substatus', 'pending_repair');// choose required substatus
    asset.update();
    count++;
    gs.print('Updated: ' + asset.number);
}

gs.print('Total updated: ' + count);

[ppicazo1]

Pointing me to the sys_choice table and the following line was the best help.   Thanks,

 asset.setValue('substatus', 'pending_repair');// choose required substatus

 was the greatest of help.   Thanks,