Page History

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

const task = new SimpleRecord('task');
task.addQuery('subject', 'like', 'not work').addOrCondition('description', 'like', 'not work');
task.query();
task.setMultipleValue('attention_required', '1');
task.updateMultiple();

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

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

current.canCreate()

current.canDelete()

current.canRead()

current.canUpdate()

const record = new SimpleRecord('sys_translation');
record.addQuery('value', 'like', 'network');
record.query();
ss.info(record.getRowCount());
// record.deleteMultiple();

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

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

if (!!table.name) {
  const record = new SimpleRecord(table.name);
  record.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!`);
  }
}

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

const task = new SimpleRecord('task');
const condition = task.addQuery('state', '7');
condition.addOrCondition('priority', '<', '3');
condition.addEncodedQuery('active=1');
task.selectAttributes('sys_id');
task.next();
ss.info(task.getConditionQuery()); // Info: ((state=7)^OR(priority<3))^(active=1)
ss.info(task.getRowCount());

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

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

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

const incident = new SimpleRecord('itsm_incident');
incident.get('150000000000000001');
ss.info(incident.getLabel('caller'))ss.error(`Field "${current.getLabel('username')}" cannot be blank`);

const incident = new SimpleRecord('itsm_incident');
incident.query();
ss.addInfoMessage('Total incident count: ' + incident.getRowCount());

const incidentotherRecord = new SimpleRecord('itsm_incident'(current.getTableName());
ssotherRecord.info(incident.getTableName()); // itsm_incident

addQuery('type', current.type);
otherRecord.addQuery('sys_id', '!=', current.sys_id);
otherRecord.selectAttributes('sys_id');
otherRecord.query();
if (otherRecord.getRowCount() > 0) {
  const messageLinks = [];
  while(otherRecord.next()) {
    messageLinks.push(
      `<a href=${ss.getProperty('simple.instance.uri')}/record/${current.getTableName()}/${otherRecord.sys_id}>${otherRecord.sys_id}</a>`);
    ;
  }
  ss.addErrorMessage(`There're some records with same type: ${messageLinks.join('\n')}`);  
}

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

ss.importIncludeScript('customEmployeeAbsent');
if (!!customEmployeeAbsent(current.getValue('assigned_user'))) {
  ss.addErrorMessage(`User ${current.assigned_user.display_name} is not available`);
}

const incident current.state == 'new SimpleRecord('itsm_incident');
incident.insert();

' && current.hasAttachment()

const tabletaskRecord = new SimpleRecord('sys_db_tabletask');
ss.info(Object.entries(tabletaskRecord.isTableVcsEnabledgetAttributes()); // true

.filter(item => !item.includes('')));
taskRecord.initialize();
ss.info(Object.entries(taskRecord.getAttributes()).filter(item => !item.includes('')));

const incidenttable = new SimpleRecord('itsm_incident');
incident.selectAttributes('sys_idsys_db_table');
incidentss.query();
while (incident.nextinfo(table.isTableVcsEnabled()){
;  ss.info(incident.sys_id);
}

// true

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

rec.description = 'dsc';
ss.info(rec.matchesCondition('descriptionLIKEesc')); // false
rec.description = 'desc';
ss.info(rec.matchesCondition('descriptionLIKEesc')); // true

const incident = new SimpleRecord('itsm_incident');
incident.orderByDesc('sys_updated_at');
incident.query(););
incident.selectAttributes('sys_id');
incident.query();
while (incident.next()){
  ss.info(incident.sys_id);
}

Do not use this method when selecting records that can be updated after being selected. Otherwise, when updating, some of the record field values may be lost, or record updating will throw an exception looking like this:

const record = new SimpleRecord('user');
record.selectAttributes('email');
record.query();
while (record.next()) {
  ss.info(record.email || 'null'); // not null
  ss.info(record.first_name || 'null'); // null
  ss.info(record.username || 'null'); // null
  // other fields are null
}

const record = 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'); // null
  // other fields are null
}

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()`);
}

const incident = new SimpleRecord('itsm_incident');
incident.orderByDesc('sys_created_at');
incident.setLimit(1);
incident.query(); // last created incident
if (incident.getRowCount() > 0) {
  incident.next();
  ss.info(`Last incident was created at ${incident.sys_created_at}`);
}

const task = new SimpleRecord('task');
task.addQuery('state', '7'); // Draft
task.query();
ss.info(task.getRowCount());
task.setMultipleValue('state', '2'); // Open
// task.updateMultiple();

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

const task = new SimpleRecord('task');
task.query();
task.next();
task.silentMode();
task.update();

const incident = new SimpleRecord('itsm_incident');
incident.get(record_id);
if (incident.sys_id) {
  incident.subject += " (repair)";
  const updatedID = incident.update();
  if (updatedID == 0) {
    ss.debug(incident.getErrors());
  }
}

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