Page History

let sysNumber = '';
sysNumber += subject.match(/[A-Z]+\d+/g);
if (!!sysNumber) {
  const taskconst taskRecord = new SimpleRecord('task');
  task.get('number', sysNumber);
  if (!!task.sys_id) {
    task.state = '10'; // Cancelled  
    task.update();
  }
}

const task = new SimpleRecord('task');
const taskcondition = new SimpleRecord('tasktask.addQuery('state', '7');
taskcondition.addQueryaddOrCondition('subjectpriority', 'like<', 'not work').addOrCondition('description', 'like', 'not work');
task.query();
task.setMultipleValue('attention_required', '1');
task.updateMultiple();

'3');
ss.info('Condition before query: ' + task.getConditionQuery());
task.query();
ss.info('Condition after query: ' + task.getConditionQuery());
// Info: Condition before query: (state=7)^OR(priority<3)
// Info: Condition after query:

const taskcurrent = new SimpleRecord('task');
task.addQuery('active', true);
task.addQuery('subject', 'like', 'сеть');
task.addQuery('sys_created_at', '<', '2019-04-01 00:00:00current.get('163663310116371174');
task.query(ss.info(current.getDisplayValue('caller'));
ss.info('Count: ' + task.getRowCount());

(current.getValue('caller'));
// Info: John Doe
// Info: 155931135900000001

const employeerecord = new SimpleRecord('employee');
employee.addEncodedQuery('%28locked_out%21%3D0%29%5EmanagerISEMPTY');
employee.query();
employee.setMultipleValue('locked_out', '0');
employee.updateMultiple();

user');
const insertedRecordId = record.insert();
if (insertedRecordId == 0) {
  ss.info(record.getErrors());
}
// Info: ["The \"\"First Name\" [first_name]\" field is mandatory. (record id: )",...

const current = ss.getUser();
const fieldLabel = current.canDelete()

.getLabel('username');
ss.addErrorMessage('Field "' +  fieldLabel + '" cannot be blank');
// Field "Login" cannot be blank

current.canUpdate()

(function executeRule(current, previous = null /*not null only when action is update*/) {
    if (current.getReModelId()) {
        const model = new SimpleRecord('sys_rmc_model');
        model.get(current.getReModelId()); // current model
        current.$$service = model.getValue('cmdb_service_id'); // pass service if field exists
    }
})(current, previous);

const recordtask = new SimpleRecord('sys_translationtask');
record.addQuery('value', 'like', 'network');
recordtask.query();
ss.info(recordaddInfoMessage('All Tasks Count: ' + task.getRowCount());
// record.deleteMultiple();

 All Tasks Count: 2

const incidentcurrent = new SimpleRecord('itsm_incident'ss.getUser();
incident.get('155931135900000000');
incident.deleteRecord();

ss.info('/list/' + current.getTableName() + '/' + current.sys_id);
// Info: /list/user/155931135900000001

const current service= new SimpleRecord('task');
current.get('c_service');
service.get(current.getValue('service'163638951512716126');
if (current.sys_id) {
    ss.info(current.rem_attr.getTitle('reviewed'));
if (!!service.sys_id) {
  const company = new SimpleRecord('org_company');
  company.get('link', service.customer_url);
  ss.eventQueue('notify.company.responsible', current);
}

}
// Info: Review completed

if (!!table.name) {
  const recordconst current = ss.getUser();
const user = new SimpleRecord(table.name'user');
  recorduser.get(recordID);
  if (record.getAttributes()['display_name'] != undefined) {
    current.display_name = `Approval for ${record.display_name}`;
  } else {
    ss.error(`Field display_name in record ${recordID} of table ${table.name} not found. Display Name for approval did not created!`);
  }
}

addQuery('timezone_id', current.getValue('timezone_id'));
user.selectAttributes('sys_id');
user.query();
ss.info(user.getRowCount() + ' users have the same timezone as you');
// Info: 24 users have the same timezone as you

email.setSubject(`New ${current.getClassDisplayValue()} has been created`);

const task = new SimpleRecord('task');
const conditiontaskRecord = new task.addQuerySimpleRecord('state', '7task');
conditionss.addOrCondition('priority', '<', '3');
condition.addEncodedQuery('active=1');
task.selectAttributes('sys_id');
task.nextinfo(taskRecord.getAttributes().caller);
taskRecord.initialize();
ss.info(tasktaskRecord.getConditionQuerygetAttributes().caller); 
// Info: ((state=7)^OR(priority<3))^(active=1)
ss.info(task.getRowCount());

// Info: 155931135900000001

email.setBody(`Dear ${current.getDisplayValue('caller').match(/^(\w+)/g)}:

Your ${current.getClassDisplayValue()} - ${current.number} has been registered`);

const newTask = new SimpleRecord('task');
newTask.subject = 'Subtask';
const inserterTaskID = newTask.insert();
ss.info(`/record/task/${inserterTaskID}`);
// Info: /record/task/163675231910113745

const table = new SimpleRecord('sys_db_table');
table.get('name', 'task');
if (!table.deleteRecord()) {
  const errors = table.getErrors();
  errors.forEach(error => {
    ss.addErrorMessage(error);
  });
}

const current = new SimpleRecord('user');
ss.info(current.isTableVcsEnabled());
// Info: false

const incidenttask = new SimpleRecord('itsm_incidenttask');
task.description = 'emaio';
incident.get('150000000000000001')ss.info(task.matchesCondition('descriptionLIKEemail')); // false
task.description = 'email';
ss.info(incidenttask.getLabelmatchesCondition('callerdescriptionLIKEemail')); // true

const incidentuser = new SimpleRecord('itsm_incident'('user');
user.setLimit(1);
user.query();
incidentuser.querynext();
ss.addInfoMessage('Total incident count: ' + incident.getRowCount());

info(user.sys_id);
// Info: 100000000000000000

:

const task = new SimpleRecord('task');
task.get('150000000000000001');
ss.info(task.getValue('assigned_user')); // 150000000534521234

 firstLog = new SimpleRecord('sys_log');
firstLog.orderBy('sys_created_at'); // oldest record first
firstLog.addQuery('message', 'like', 'Connection');
firstLog.setLimit(1);
firstLog.selectAttributes(['message', 'sys_created_at']);
firstLog.query();
firstLog.next();
ss.info(firstLog.sys_created_at + ' - ' + firstLog.message);
// Info: 2021-06-03 06:34:02 - IMAP IMAP (Default): Connection error: ...

const tasklastComment = new SimpleRecord('task');
task.get('157531598110402540' SimpleRecord('sys_activities_stream_field');
lastComment.orderByDesc('sys_created_at'); // newest record first
lastComment.setLimit(1);
lastComment.selectAttributes(['value', 'sys_created_by']);
lastComment.query();
lastComment.next();
ss.info(task.hasAttachment()); // false

lastComment.sys_created_by.display_name + ': ' + lastComment.value);
// Info: John Doe: test

const taskRecordtasks = new SimpleRecord('task');
sstasks.info(Object.entries(taskRecord.getAttributes()).filter(item => !item.includes('')));
taskRecord.initialize();
ss.info(Object.entries(taskRecord.getAttributes()).filter(item => !item.includes('')));

addQuery('sys_created_at', '>', '2020-01-01');
tasks.orderBy('sys_created_at');
tasks.setLimit(2);
tasks.query();
while (tasks.next()) {
  ss.info('Task number: ' +  tasks.number);
}
// Info: Task number: TSK0000001
// Info: Task number: TSK0000003

const taskrecord = new SimpleRecord('taskuser');
rec.description = 'dsc';
ss.info(rec.matchesCondition('descriptionLIKEesc')); // false
rec.description = 'desc';
ss.info(rec.matchesCondition('descriptionLIKEesc')); // true

record.selectAttributes('email');
record.query();
record.next();
ss.info(record.getAttributes());
// Info: {"email":"john.doe@email.com","sys_id":"162423321917274937"}

const incidentrecord = new SimpleRecord('itsm_incidentuser');
incidentrecord.selectAttributes('sys_id'['email', 'username']);
record.query();
incidentrecord.querynext();
while (incident.nextss.info(record.getAttributes()){;
//  ss.info(incident.sys_id);
}

Info: {"email":"john.doe@email.com","username":"john.doe","sys_id":"162423321917274937"}

const incident = new SimpleRecord('itsm_incident');
incident.orderBy('sys_created_at');
incident.query();

const current = new SimpleRecord('task');
current.get('163663310116371174');
const hasAttach = current.hasAttachment();
if (!hasAttach) {
    ss.addErrorMessage('File should be attached!');
    current.setAbortAction(true);
}
current.state = '2'; // Open
current.update();

const incidentrecord = new SimpleRecord('itsm_incident');
incident.orderByDesc('sys_updated_atuser');
incident.query();

record

.setLimit(3);
record.query();
ss.info(record.getRowCount());
// Info: 3

const recordtask = new SimpleRecord('usertask');
recordtask.selectAttributesaddQuery('emailstate', '7'); // Draft
recordtask.query();
while (record.nextss.info(task.getRowCount()) {
  ss.info(record.email || 'null;
task.setMultipleValue('state', '2'); // not null
  ss.info(record.first_name || 'null'); // null
  ss.info(record.username || 'null'); // null
  // other fields are null
}// Open
// task.updateMultiple();

const recordtask = new SimpleRecord('user');
record.selectAttributes(['email', 'first_name']);
record.query();
while (record.next()) {
  ss.info(record.email || 'null'); // not null
  ss.info(record.first_name || 'null'); // not null
  ss.info(record.username || 'null SimpleRecord('task');
task.get('163352033916904699');
if (task.getValue('service') === '164069027812962298') { // Email Server Service
    task.setReModelId('158569205818704980'); // null
  // other fields are null
}

 Email Server Access Request
} else {
    task.setReModelId(null);
}
task.update();

.

const now = new SimpleDateTime(); // now

if (now.before(new SimpleDateTime(current.appropriate_date))) {
  current.setAbortAction(true);
  ss.addErrorMessage(`Can't be updated before ${new SimpleDateTime(current.appropriate_date)}.getDisplayValue()`);
}

(function executeRule(current, previous = null /*not null only when action is update*/ ) {
    // before rule triggered by service change

    ss.importIncludeScript('getRemAttributes');
    const rmc = new SimpleRecord('sys_rmc_model');
    rmc.addQuery('cmdb_service_id', current.getValue('service'));
    rmc.addQuery('active', true);
    rmc.selectAttributes('sys_id');
    rmc.setLimit(1);
    rmc.query();
    if (rmc.next()) {
        const previousModelAttributes = getRemAttributes(current);
        current.setReModelId(rmc.sys_id);
        const currentModelAttributes = getRemAttributes(current);

        Object.keys(previousModelAttributes).forEach(attributeName => {
            if (currentModelAttributes.hasOwnProperty(attributeName)) {
                current.rem_attr[attributeName] = previousModelAttributes[attributeName];
            }
        })
    } else {
        current.setReModelId(null);
    }

})(current, previous);

const task = new SimpleRecord('task');
task.setValue('subject', 'mail');
task.insert();

const task = new SimpleRecord('task');
task.addQuery('active', false);
task.addQuery('approval_state', 'isemptyconst task = new SimpleRecord('task');
task.query();
ss.info(task.nextgetRowCount());
task.silentMode();
task.setMultipleValue('approval_state', 'not_requested'); // set Default Value
//task.updateupdateMultiple();

• did not exist

• before, the getErrors() method will return this error: "Unable to update new record. Use `insert()` instead. (record id: )"

const incidentcurrent = new SimpleRecord('itsm_incidentuser');
incidentcurrent.get(record_id);
if (incident.sys_id) {
  incident.subject += " (repair)";
  const updatedID = incidentss.getUserId());
current.timezone_id = '156076775207670452'; // UTC
ss.info(current.update();
  if (updatedID == 0) {
    ss.debug(incident);
ss.info(current.getErrors());
// Info: }
}155931135900000001
// Info: []

const task = new SimpleRecord('task');
task.addQuery('state', '0'); // Open
task.query();
ss.info(task.getRowCount());
task.setMultipleValue('state', '10'); // Canceled
// task.updateMultiple();