When trying to run a report on asmt_metric_result I add a related column Instance.Trigger ID and it shows empty in the report. When I run a background script
var gr = new GlideRecord('asmt_metric_result');
gr.addQuery('sys_id', 'sample sys_id')
gr.query();
while (gr.next()) {
gs.print('Metric Result: ' + gr.sys_id + ', Trigger ID: ' + gr.instance.trigger_id);
}
I get a sys_id in return. When I open up a record in asmt_metric_result and open the record in the Instance field I see Trigger ID on the asmt_assessment_instance form is populated. Why is the report returning empty?
