background script

[Community Alums]

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 · Accepted solution]

@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.

[Community Alums]

Actually I want to delete that record using background script

[AnveshKumar M]

Hi @Community Alums 

Do you want script for Business Rules?

There should be some reference field on Table 2 referring to the record in Table 1 for better management.

You might need to create 3 BRs, After - Insert, After - Update and Before - Delete on table 1. Please let me know if you want script for all the three BRs.

[Community Alums]

Hello Anvnesh,

Im really greatful if you could provide me that code.

Thanks in advance.

[Sandeep Rajput · Accepted solution]

@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.