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);
}

[Meloper]

Thanks for your help

[Ankur Bawiskar]

@Meloper 

Reason being

1) parent field on HR Case refers to task table

2) the template field is present on sn_hr_core_case table so you cannot dot walk in the query

If you try to form the query from the filter it won't show the template field as well

Regards
Ankur

[Ankur Bawiskar]

@Meloper 

From which scope you are running this.

Also did you check the HR case is active

Regards
Ankur

[Pranav Bhagat]

You can use Background scripts to test it .

I also see you are using table as hr_case, are you using legacy HR Application ?

Regards

Pranav

[Ankur Bawiskar]

Hi,

Is that HR Case Active?

Is the Parent HR Case for this case has template populated or not

Also from which scope you are running this script

Regards
Ankur