Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- NewInclude.prototype = {
- initialize : function() {
- },
- newInclude: function()
- {
- var usersWithTasks = [];
- var userWithoutTask = [];
- var res;
- var taskAgg = new GlideAggregate('task');
- taskAgg.addAggregate('COUNT');
- taskAgg.addQuery('sys_created_by', '!=', '');
- taskAgg.groupBy('sys_created_by');
- var allCreatedBy = 0;
- taskAgg.query();
- while(taskAgg.next()) {
- usersWithTasks.push(taskAgg.getValue('sys_created_by'));
- allCreatedBy++;
- }
- var usersAll = new GlideRecord('sys_user');
- usersAll.addQuery('user_name', '!=', '');
- usersAll.addQuery('active', 'true');
- usersAll.query();
- while(usersAll.next()) {
- var userID = usersAll.getValue('user_name');
- if (usersWithTasks.indexOf(userID) === -1) {
- userWithoutTask.push(usersAll.getValue('sys_id'));
- }
- }
- //gs.log("PNA " + userWithoutTask);
- return 'sys_idIN'+ userWithoutTask.toString();
- },
- type : 'NewInclude'
- };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement