How to do dot walk in two different reference fields to get the value of the email field?

[Elton2]

Hi everyone, how are you?!

In order for me to be able to get the value of the "email" field, I initialize it using the form in the first
table (cmdb_cit_business) then I need to do a dot walk, in two different tables, because the field is a reference (Business Parnet Department) PRINT_1:

Within this field there is another table (cmn_department) where there is the "Holder" field (which is also a reference field) PRINT_2

In turn, there is another table (sys_user), this will have the email field, which I need to get the value of. PRINT_3

I tried to do it this way, but it's not working, does anyone have any suggestions?

var grCmdb = new GlideRecord('cmdb_cit_business');

grCmdb.addEncodedQuery('u_business_partner_departmentISNOTEMPTY^active=true');

grCmdb.query();

while (gr.next()){

    var grCmnDept = new GlideRecord('cmn_department');

    grCmnDept.addQuery('dept_head_one', '!=', '');

    grCmnDept.query();

}

Tks so much

[Dibyaratnam · Accepted solution]

Here i have taken example of incident table.

It has Configuration item Reference field. then the table contains a Owned by field, which refers to sys_user table where the Mail field is present.

Check the below script to find mail .

var grCmdbInc = new GlideRecord('incident');
grCmdbInc.addEncodedQuery('cmdb_ciISNOTEMPTY^active=true^sys_id='+recordsysId);
grCmdbInc.query();
while (grCmdbInc.next()){
    if(grCmdbInc.cmdb_ci.owned_by&&grCmdbInc.cmdb_ci.owned_by.email){
        gs.info(grCmdbInc.cmdb_ci.owned_by.email);
    }
    
}

Make the changes as per your requirement and you should be able to get the data. 

Just to point out, in your script, in while loop, you have written gr.next(), instead of grCmdb.next()

Please mark as correct if it helps.

[Dibyaratnam · Accepted solution]

Check this article https://developer.servicenow.com/dev.do#!/learn/learning-plans/tokyo/servicenow_administrator/app_st...

In condition field, it will evaluate for the condition to send the mail, so this field will only return true/false. nothing else. Is that the same purpose you are using the script?

By recordsysid, i meant sysid of a specific record, for testing purpose. 

What exactly you want to achieve from that script.

[Dibyaratnam · Accepted solution]

Check the article below. In gs.eventqueue method, in the parameters you can pass the recipient as one of the parameters. So this should solve your issue.

It'll be like, gs.eventQueue('eventname',current,holderName);

You are already getting the holderName from the previous script that I had shared. So you should be good to go.

https://developer.servicenow.com/dev.do#!/learn/learning-plans/tokyo/new_to_servicenow/app_store_lea...

Please mark as helpful if it helps.

[Elton2]

Hi @Dibyaratnam , how are you?!
I'm very happy because it's working!!!
I studied the link you shared with me and saw that in the "Who Will Receive" Section itself, there is a the dot walk option in "User/Groups in Fields", just access the field and select "plus".
And in the BR "Advanced" section it is necessary to pass 2 more parameters which are: current, current.<reference field name>
Thank you for your attention, dedication and professionalism.
See you soon and have a great day! 

😃

[Dibyaratnam]

I am glad it worked @Elton2 . Happy Learning✌️. You too have a great day😀