how to get name from script include instead of sys_id?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-04-2019 03:51 AM
I have to create module which shows all cases which opened_for.department is same as current users Access Department(field available on HR profile table).Scope is cases of all child department as well.
My script include is :
finaldepart: function () {
var cuser = gs.getUserID();
var finaldep = [];
var viewdep = new GlideRecord( 'sn_hr_core_profile' );
viewdep.addQuery("user", cuser);
viewdep.addQuery("u_access_dep","!=",'');
viewdep.query();
if (viewdep.next()){
return viewdep.u_access_dep;
}
else {
return null;
}
},
allDepartment: function() {
var myDept = this.finaldepart();
var deptmt = [];
var child = new GlideRecord( 'dept table' );
child.addQuery( 'u_active', true );
child.addQuery( 'u_parent', myDept);
child.query();
while (child.next()){
deptmt.push(child.sys_id.toString());
}
deptmt.push(myDept.toString());
return deptmt.join(',');
},
I am not able to convert sys_id into department names from this.Any suggestions?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-04-2019 04:12 AM
It didnt work.i had already tried.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-05-2019 07:07 PM
These may be a separate issue but does viewdep return records?
viewdep.addQuery("u_access_dep","!=",'');
might be better with:
viewdep.addNotNullCondition('u_access_dep');