below script is not working properly please check and let me know my mistake

[mani55]

i am trying to set one value is empty and i tried below script but still not working please check and help me anyone with my mistake

var test1 = new GlideRecord('alm_hardware');
    test1.get('u_premium_service.u_number='+ritm.variables.hardware_asset^asset_tag!=ritm.variables.hardware_asset^ORasset_tag=NULL');

    //remove PREMxxxx01 from hardware asset table
    test1.u_premium_service = "";


    test1.update();

[Anurag Tripathi · Accepted solution]

Hi,

Try this

var test1 = new GlideRecord('alm_hardware');
test1.addEncodedQuery('u_premium_service.u_number='+ritm.variables.hardware_asset+'^asset_tag!='+ritm.variables.hardware_asset+'^ORasset_tag=NULL');
test1.query();
while(test1.next()) //use if if you are expecting only 1 record to be returned
    //remove PREMxxxx01 from hardware asset table
    test1.u_premium_service = "";
    test1.update();
}

[Ankur Bawiskar]

@mani55 

your query is wrong.

form the correct query with correct fields and the operators i.e. AND, OR

[Ankur Bawiskar]

@mani55 

what is stored in that variable hardware_asset?

you are comparing it against asset_tag field and also against u_premium_service.u_number