Good Morning,
i have an issue where i am trying to apply dual fitlers onto a reference fields on a custom table.
the two reference fields are
Office -> cmn_location table
Department -> cmn_department table
the third field i need to filter base on the office + department
This third field is a reference to a custom table called u_gl_codes and the columns in this table (Office and Department) is also link to the cmn_location for Office and cmn_department for department
I need to be able to filter out the list when users select the office on the table and department to see only the filter of the Gl Codes
i have tried many options which nothing has worked
If I understand correctly, you have a new custom table for GL codes that has 2 reference fields for office and deparment. There is another table that has the same two reference fields plus a reference field to the GL codes table. If so, I duplicated that in my PDI.
the script include is named 'officeDeptCodes' and follows:
function officeDeptCodes(office, dept) {
var codes = new GlideRecord('u_gl_codes');
var result = [];
codes.addQuery('u_office', office);
codes.addQuery('u_department', dept);
codes.query();
// gs.info('officeDeptCodes: Found ' + codes.getRowCount() + ' records');
while(codes.next()) {
result.push(codes.sys_id.toString());
}
// gs.info('officeDeptCodes: returning: ' + result);
return result;
}
my table that has a reference field to the GL codes table has the field defined as:
javascript:'sys_idIN'+officeDeptCodes(current.u_office, current.u_department);
As I said earlier you need to be specific on what you want. Change field and table names to match what you have.
