Added the alm_hardware table work notes

vinuth v
Tera Expert

‎06-13-2023 07:39 AM

Hi All,

I am working on one of the form in this form I am using "What is the type of request?" drop down field,

This form contains one more variable set called "Asset(s) to return to stock" and it contains Comment field.

 

My query is I wanted to update the alm_hardware table worknotes like "What is the type of request?" - Comment.

vinuthv_0-1686666836611.png

I tried with the below code

 

 
var abc;
var worknotes="work_notes";
var Request=current.variables.request_type;
 
var Commment=current.variables.asset_s_to_return_to_stock.v_comments;
gs.log("CommmentCommment"+Commment);                 //getting like this CommmentCommment[test]
abc=current.variables.asset_s_to_return_to_stock
var multiRowSet = [];
var ass;
var sub;
var stockroom=current.variables.return_to_stockroom;
multiRowSet.push(abc);
multiRowSet = JSON.parse(multiRowSet);
for (var i = 0; i < multiRowSet.length; i++) {
ass = multiRowSet[i].v_asset;
sub = multiRowSet[i].v_substate;
gs.log("asssub " + i + multiRowSet[i].v_asset+"/"+multiRowSet[i].v_substate);
var gr1 = new GlideRecord('alm_hardware');  
gr1.addQuery('sys_id',multiRowSet[i].v_asset);
gr1.query();
if(gr1.next()){
gr1.install_status = "6";
gr1.substatus = multiRowSet[i].v_substate;
gr1.stockroom=stockroom;
gr1[worknotes].setJournalEntry(Request+" "+ "-"+" "+Commment);
gr1.update();
}
}    
I am getting like this on the alm_hardware table worknotes
vinuthv_1-1686667073487.png

 

Please any one provide me the input

Thanks in advance,

Vinuth

 

 

0 Helpfuls
  • 330 Views
1 REPLY 1

Manmohan K
Tera Sage

‎06-13-2023 09:08 AM

Hi @vinuth v 

 

Try with below code

var abc;
var worknotes = "work_notes";
var Request = current.variables.request_type;


gs.log("CommmentCommment" + Commment); //getting like this CommmentCommment[test]
abc = current.variables.asset_s_to_return_to_stock;
var multiRowSet = [];
var ass;
var sub;
var Commment;
var stockroom = current.variables.return_to_stockroom;
multiRowSet.push(abc);
multiRowSet = JSON.parse(multiRowSet);
for (var i = 0; i < multiRowSet.length; i++) {
    ass = multiRowSet[i].v_asset;
    sub = multiRowSet[i].v_substate;
    Commment = multiRowSet[i].v_comments;
    gs.log("asssub " + i + multiRowSet[i].v_asset + "/" + multiRowSet[i].v_substate);
    var gr1 = new GlideRecord('alm_hardware');
    gr1.addQuery('sys_id', multiRowSet[i].v_asset);
    gr1.query();
    if (gr1.next()) {
        gr1.install_status = "6";
        gr1.substatus = multiRowSet[i].v_substate;
        gr1.stockroom = stockroom;
        gr1[worknotes].setJournalEntry(Request + " " + "-" + " " + Commment);
        gr1.update();
    }
}
0 Helpfuls