Dot-walking in a GlideRecord addQuery()

[Meloper]

Ist that Possible?

check();

function check() {
    var gr = new GlideRecord("hr_case");
	gr.addActiveQuery();
	gr.addQuery('parent.template', '16c971f9db58ec14066c4f63059619b8');
	gr.query();
	gr.next();
		gs.info(gr.parent.template);
}

[Mark Roethof]

Hi there,

Yes that should be possible.

Are you running into any issues?

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Meloper]

Yes with this example 😉

I tested it wiht a Fix Sript.

Error ist to long to copy

I have also heard that if an error occurs, too many GR elements could be created

[Mark Roethof]

So can you see anything in that error? For example table hr_case might be incorrect. I would expect sn_hr_case or sn_hr_core_case.

Also double check the template sys_id.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

[Ankur Bawiskar]

@Meloper 

this should work fine

Can you try to use if(gr.next()) in order to print the value

check();

function check() {
    var gr = new GlideRecord("sn_hr_core_case");
    gr.addActiveQuery();
    gr.addQuery('parent.template', '16c971f9db58ec14066c4f63059619b8');
    gr.query();
    gr.next();
    if(gr.next()){
        gs.info(gr.parent.template);
    }
}

Regards
Ankur