Script to insert record in custom table

Sneha39 · ‎02-10-2022

I want to insert catalog item variable record to custom table as soon as the RITM gets created.

I am writing after BR on ritm table( its not working) for same but looking for more suggestions.

(function executeRule(current, previous /*null when async*/) {

// Add your code here

var tbl1 = new GlideRecord('u_cst_account');
tbl1.query();
if(tbl1.next())
{
var rec1=tbl1.u_account_names;
if(current.variables.var_type1 == 'AST1')
{
current.variables.var_name = rec1;
tbl1.setValue(name,current.variables.var_name);

}
}

})(current, previous);

Prasad Pagar · ‎02-10-2022

Ok if its inserting of record

then you need to do 2 things

1. Make a check if same record exist

2. If Yes then ignore or If No then insert

var recinsert = new GlideRecord('u_cst_account');\
recinsert.addQuery('columnename',current.variables.var_name);//add here column name against which you want to check
recinsert.query();
if(!recinsert.next()) //If no record found
{
var recinsertnow = new GlideRecord('u_cst_account');
recinsert.initialize();
recinsert.setValue(name,current.variables.var_name);
recinsert.insert();
}

Hope this helps

Thank you
Prasad

View solution in original post

Prasad Pagar · ‎02-10-2022

Did you mapped the variables correctly? Can you show me your script?

Sneha39 · ‎02-10-2022

Tried from background script. its still inserting empty record

Mubashira · ‎08-07-2023

Great Solution!

Jake Sadler · ‎02-10-2022

Hi,

This line:

tbl1.setValue(name,current.variables.var_name);

name needs to be 'name' as it is a field.

correct script line:

tbl1.setValue('name',current.variables.var_name);

I also recommend adding tbl1.update();

If this solved your issue please mark my answer correct.

Thanks

Jake

Jake Sadler · ‎02-10-2022

Hi,

I misread your initial question.

To insert a record you must use the below script:

(function executeRule(current, previous /*null when async*/) {

// Add your code here

var tbl1 = new GlideRecord('u_cst_account');
tbl1.query();
if(tbl1.next())
{
var rec1=tbl1.u_account_names;
if(current.variables.var_type1 == 'AST1')
{

current.variables.var_name = rec1;

var tbl1Insert = new GlideRecord('u_cst_account');

tbl1Insert.initialize();
tbl1Insert.setValue'(name',current.variables.var_name);
tbl1Insert.insert();
}
}

})(current, previous);