- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2022 07:21 AM
I have created a Script Include method to fetch fields and corresponding values of a user record from User table. I am trying to build a JSON object for the records without an empty values. I am getting JSON object output with null values as well which I want not to include while building. Can anyone help.
getCreatedBy: function(taskRecord) {
var userArray = [];
var taskUser = new GlideRecord('sys_user');
taskUser.addQuery('sys_id', '35f8c8932f8068100d5aa85df699b62c');
taskUser.query();
if (taskUser.next()) {
var fields = new GlideRecordUtil().getFields(taskUser);
var fieldName = '';
for (var i = 0; i < fields.length; i++) {
fieldName = fields[i];
var obj={};
if(taskUser.getDisplayValue(fieldName) != '');
obj[fieldName]=taskUser.getDisplayValue(fieldName);
userArray.push(obj);
}
}
gs.log(JSON.stringify(userArray));
return userArray;
},
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2022 07:50 AM
Hi,
update as this
getCreatedBy: function(taskRecord) {
var userArray = [];
var taskUser = new GlideRecord('sys_user');
taskUser.addQuery('sys_id', '35f8c8932f8068100d5aa85df699b62c');
taskUser.query();
if (taskUser.next()) {
var fields = new GlideRecordUtil().getFields(taskUser);
var fieldName = '';
for (var i = 0; i < fields.length; i++) {
fieldName = fields[i];
var obj = {};
if(taskUser.getDisplayValue(fieldName) != ''){
obj[fieldName]=taskUser.getDisplayValue(fieldName);
userArray.push(obj);
}
}
}
gs.log(JSON.stringify(userArray));
return userArray;
},
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2022 07:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-09-2022 07:50 AM
Hi,
update as this
getCreatedBy: function(taskRecord) {
var userArray = [];
var taskUser = new GlideRecord('sys_user');
taskUser.addQuery('sys_id', '35f8c8932f8068100d5aa85df699b62c');
taskUser.query();
if (taskUser.next()) {
var fields = new GlideRecordUtil().getFields(taskUser);
var fieldName = '';
for (var i = 0; i < fields.length; i++) {
fieldName = fields[i];
var obj = {};
if(taskUser.getDisplayValue(fieldName) != ''){
obj[fieldName]=taskUser.getDisplayValue(fieldName);
userArray.push(obj);
}
}
}
gs.log(JSON.stringify(userArray));
return userArray;
},
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader