background script

Community Alums · ‎09-27-2023

I'm having two tables table1 and table2, I have written script for insertion of record once I insert record in table1 automatically in table2 record should be create here is my script

var gr = new GlideRecord("u_mytable");

gr.u_name = "abraham.lincoln";

gr.u_mobile_number = "040-00282262";

gr.insert();

var grc = new GlideRecord("u_mytablecopy");

grc.u_name = gr.u_name;

grc.u_mobile_number = gr.u_mobile_number;

grc.insert();

Now I want to use same case for deletion

Sandeep Rajput · ‎09-27-2023

@Community Alums Here is how you should write your script.

var gr = new GlideRecord("u_mytable");
gr.addQuery('u_name',"abraham.lincoln");
if(gr.next()){
var grc = new GlideRecord("u_mytablecopy");
grc.addQuery('u_name',gr.getValue('u_name'));
if(grc.next()){
grc.delete();
}
gr.delete()
}

Hope this helps.

View solution in original post

Manisha Reddy K · ‎09-27-2023

Hi @Community Alums ,

Please use gr.initialize() when your inserting the new record.

var gr = new GlideRecord("u_mytable");

gr.initialize();

gr.u_name = "abraham.lincoln";

gr.u_mobile_number = "040-00282262";

gr.insert();

var grc = new GlideRecord("u_mytablecopy");

grc.initialize();

grc.u_name = gr.u_name;

grc.u_mobile_number = gr.u_mobile_number;

grc.insert();

Deletion code:

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

var deleteRecord;

var gr = new GlideRecord("u_mytable");

gr.addQuery('sys_id', 'the sys_id of record to be deleted');

gr.query();

if(gr.next()){

deleteRecord = gr.getValue('sys_id');

gr.deleteRecord();

}

var grc = new GlideRecord("u_mytablecopy");

grc.addQuery('sys_id', deleteRecord);

grc.query();

if(grc.next()){

grc.deleteRecord();

}

View solution in original post

Slava Savitsky · ‎11-02-2023

What does this have to do with ServiceNow?

Blog: https://sys.properties | Telegram: https://t.me/sys_properties | LinkedIn: https://www.linkedin.com/in/slava-savitsky/