How to combine to multiple email scripts on different tables as one email script ?

[Community Alums]

Hi everyone, 

How can we combine multiple email scripts as one email script for fetching data on email body for different tables.

Scripts:

 var gr = new GlideRecord("cmdb_ci_business_app");
    gr.addQuery('assigned_to.name', event.parm2);
    gr.query();
    while (gr.next()) {
        template.print(gr.number);
        template.print("<br/>");
    }   

 var gr = new GlideRecord("cmdb_ci_service_discovered");
    gr.addQuery('assigned_to.name', event.parm2);
    gr.query();
    while (gr.next()) {
        template.print(gr.number);
        template.print("<br/>");
    }

Thanks @Ankur Bawiskar , @Mohith Devatte 

[Ankur Bawiskar]

Hi,

but the data shown by both email scripts is different.

what is the email script after merging? share the script

Regards
Ankur

[Community Alums]

Hi,
after merging for both email scripts.

Script:

 var gr = new GlideRecord("cmdb_ci_business_app");
    gr.addQuery('assigned_to.name', event.parm2);
    gr.query();
    while (gr.next()) {
        template.print(gr.number);
        template.print("<br/>");
    }

    var gr1 = new GlideRecord("cmdb_ci_service_discovered");
    gr1.addQuery('assigned_to.name', event.parm2);
    gr1.query();
    while (gr1.next()) {
        template.print(gr1.number);
        template.print("<br/>");
    }

[Tony Chatfield1]

If you have the 2 glide queries, shown in you post, in 1 script they cannot both be instantiated as gr, so you need to change one.

 var gr = new GlideRecord("cmdb_ci_business_app");
    gr.addQuery('assigned_to.name', event.parm2);
    gr.query();
    while (gr.next()) {
        template.print(gr.number);
        template.print("<br/>");
    }   

 var anotherName = new GlideRecord("cmdb_ci_service_discovered");
    anotherName.addQuery('assigned_to.name', event.parm2);
    anotherName.query();
    while (anotherName.next()) {
        template.print(anotherName.number);
        template.print("<br/>");
    }

[Community Alums]

Hi,

After merging I am not getting exact output.

Thanks

[Tony Chatfield1]

Hi, ‘I am not getting exact output’ has no context as a response.
How does your question reconcile to the answer flagged as correct?