I have Company Field (Field: company, Table: core_company) on Incident Form. I want to populate Assignment group(Field: assignment_group, Table: sys_user_group) based on value selected in company field. How can this be achieved with Ajax calls.
I have tried using reference qualifier but seems it isn't working.
I have created a m2m mapping between the 2 tables in u_m2m_group_companies.
Advance Reference Qualifier used :
Script Include :
var BackfillAssignmentGroupCompany = Class.create();
BackfillAssignmentGroupCompany.prototype = {
initialize: function() {
},
BackfillAssignmentGroupCompany:function() {
var gp = ' ';
var a = current.company;
//return everything if the company value is empty
if(!a)
return;
//u_m2m_groups_companies has the user to group relationship
var grp = new GlideRecord('u_m2m_groups_companies');
grp.addQuery('u_company',a);
grp.query();
while(grp.next()) {
if (gp.length > 0) {
//build a comma separated string of groups if there is more than one
gp += (',' + grp.u_group);
}
else {
gp = grp.u_group;
}
}
// return Groups where assigned to is in those groups we use IN for lists
return 'sys_idIN' + gp;
},
type: 'BackfillAssignmentGroupCompany'
}
1 ACCEPTED SOLUTION
