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 taskrecord = new SimpleRecord('task');
taskrecord.addQueryget('subject', 'like', 'not work').addOrCondition('description', 'like', 'not work');
task.query();
task.setMultipleValue('attention_required', '1');
task.updateMultiple();

160638931615274614');
if (record.getReModelId()) {
    ss.info(record.rem_attr.description);
}

const taskrecord = new SimpleRecord('task');
taskrecord.addQuery('active', true);
task.addQuery('subject', 'like', 'сетьnot work');
taskrecord.addQueryaddOrCondition('sys_created_atdescription', '<like', '2019-04-01 00:00:00');
task.query(not work');
ss.info('CountCondition query: ' + taskrecord.getRowCountgetConditionQuery());

record.query();
// Info: Condition query: (subjectLIKEnot work)^OR(descriptionLIKEnot work)

constlet employeerecord = new SimpleRecord('employeetask');
employeerecord.addEncodedQueryaddQuery('%28locked_out%21%3D0%29%5EmanagerISEMPTYsubject', 'like', 'not work');
employeerecord.query(addOrCondition('166972638116358001:description', 'contains', 'not work');
employeess.setMultipleValueinfo('locked_out', '0'Condition query: ' + record.getConditionQuery());
employeerecord.updateMultiplequery();

// Info: Condition query: (subjectLIKEnot work)^OR(166972638116358001:descriptionLIKEnot work)

:

current.canCreate()

const recordcurrent = new SimpleRecord('sys_translationtask');
record.addQuery('value', 'like', 'networkcurrent.get('163663310116371174');
record.query()ss.info(current.getDisplayValue('caller'));
ss.info(recordcurrent.getRowCountgetValue('caller'));
// Info: John Doe
// Info: 155931135900000001

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

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

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

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

if(function (!!table.nameexecuteRule(current, previous = null /*not null only when action is update*/) {
  const record = newif SimpleRecord(tablecurrent.name);
  record.get(recordID);
  if (record.getAttributes()['display_name'] != undefined) {getReModelId()) {
        const model = new SimpleRecord('sys_rmc_model');
    current.display_name = `Approval for ${record.display_name}`;
  } else { model.get(current.getReModelId()); // current model
    ss.error(`Field display_name in record ${recordID} of table ${table.name} not found. Display Name for approval did not created!`);
 current.$$service = model.getValue('cmdb_service_id'); // pass service if field exists
    }
}

)(current, previous);

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

const task = new SimpleRecord('task');
task.query();
ss.addInfoMessage('All Tasks Count: ' + task.getRowCount());
// All Tasks Count: 2

const current = ss.getUserconst 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());

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

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

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

const current = new SimpleRecord('task');
current.get('163638951512716126');
if (current.sys_id) {
    ss.info(current.rem_attr.getTitle('reviewed'));
}
// Info: Review completed

.

const current = ss.getUser();
const user = new SimpleRecord('user');
user.addQuery('timezone_id', current.getValue('timezone_id'));
user.selectAttributes('sys_id');
user.query();
ss.info(user.errorgetRowCount(`Field "${current.getLabel('username')}" cannot be blank`);

) + ' users have the same timezone as you');
// Info: 24 users have the same timezone as you

const incidentcurrent = new SimpleRecord('itsm_incidenttask');
current.get('163663310116371174');
incident.queryconst hasAttach = current.hasAttachment();
if (!hasAttach) {
  ss.addInfoMessageaddErrorMessage('Total incident count: ' + incident.getRowCount());

File should be attached');
  return;
}
current.state = '2'; // Open
current.update();

const otherRecordtaskRecord = new SimpleRecord(current.getTableName());
otherRecord.addQuery SimpleRecord('typetask', current.type);
otherRecordss.addQuery('sys_id', '!=', current.sys_id);
otherRecord.selectAttributes('sys_id');
otherRecord.queryinfo(taskRecord.getAttributes().caller);
taskRecord.initialize();
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')}`);  
}

ss.info(taskRecord.getAttributes().caller);
// Info: 
// Info: 155931135900000001

const current = new SimpleRecordss.importIncludeScript('customEmployeeAbsentuser');
if (!!customEmployeeAbsentss.info(current.getValueisTableVcsEnabled('assigned_user'))) {;
//  ss.addErrorMessage(`User ${current.assigned_user.display_name} is not available`);
}

Info: false

current.state == 'new' && current.hasAttachment()

const task = new SimpleRecord('task');
task.description = 'emaio';
ss.info(task.matchesCondition('descriptionLIKEemail')); // false
task.description = 'email';
ss.info(task.matchesCondition('descriptionLIKEemail')); // true

const taskRecorduser = new SimpleRecord('task')
ss.info(Object.entries(taskRecord.getAttributes()).filter(item => !item.includes(''))user');
taskRecorduser.initializesetLimit(1);
ssuser.info(Object.entries(taskRecord.getAttributes()).filter(item => !item.includes('')));

query();
user.next();
ss.info(user.sys_id);
// Info: 100000000000000000

const tablefirstLog = new SimpleRecord('sys_log');
firstLog.orderBy('sys_created_at'); // oldest record first
firstLog.addQuery('message', 'like', 'Connection');
firstLog.setLimit(1);
firstLog.selectAttributes(['sys_db_table'message', 'sys_created_at']);
firstLog.query();
firstLog.next();
ss.info(table.isTableVcsEnabled()); // true

firstLog.sys_created_at + ' - ' + firstLog.message);
// Info: 2021-06-03 06:34:02 - IMAP IMAP (Default): Connection error: ...

const tasklastComment = new SimpleRecord('tasksys_activities_stream_field');
rec.description = 'dsc';
ss.info(rec.matchesCondition('descriptionLIKEesc')); // false
rec.description = 'desc'lastComment.orderByDesc('sys_created_at'); // newest record first
lastComment.setLimit(1);
lastComment.selectAttributes(['value', 'sys_created_by']);
lastComment.query();
lastComment.next();
ss.info(rec.matchesCondition('descriptionLIKEesc')); // true

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

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

const tasks = new SimpleRecord('task');
tasks.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 record firstComment= new SimpleRecord('sys_activities_stream_fielduser');
firstCommentrecord.addQueryselectAttributes('element_id', current.sys_id);
firstComment.orderBy('sys_created_at');
firstComment.setLimit(1); // very first message
firstCommentemail');
record.query();
record.next();
ss.info(record.getAttributes());
// Info: {"email":"john.doe@email.com","sys_id":"162423321917274937"}

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

const logMessage = new SimpleRecord('sys_log');
logMessage.addQuery('level', 'debug');
logMessage.addQuery('message', 'startswith', 'Missed values generation');
logMessage.orderByDesc('sys_created_atcurrent = new SimpleRecord('task');
logMessage.setLimit(1); // last message
logMessage.selectAttributes(['message']);
logMessage.query();
if (logMessage.getRowCount() > 0) {
  logMessage.next();
  if (logMessage.message.match(/(?<=LastTable: )(.\w+)/g))current.get('163663310116371174');
const hasAttach = current.hasAttachment();
if (!hasAttach) {
    lastTable = logMessage.message.match(/(?<=LastTable: )(.\w+)/g)[0];
  }
}

ss.addErrorMessage('File should be attached!');
    current.setAbortAction(true);
}
current.state = '2'; // Open
current.update();

const recordtask = new SimpleRecord('usertask');
recordtask.selectAttributesaddQuery('email'state', '7'); // Draft
recordtask.query();
while (record.nextss.info(task.getRowCount()) {
  ss.info(record.email || 'null'); // not null
  ss.info(record.first_name || 'null'); // null
  ss.info(record.username || 'null'); // null
  // other fields are null
};
task.setMultipleValue('state', '2'); // 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 || 'nullSimpleRecord('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()`);
}

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

const task = new SimpleRecord('taskconst task = new SimpleRecord('task');
task.addQuery('active', false);
task.addQuery('approval_state', 'isempty');
task.query();
ss.info(task.getRowCount());
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 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(incidentcurrent = new SimpleRecord('user');
current.get(ss.getUserId());
current.timezone_id = '156076775207670452'; // UTC
ss.info(current.update());
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();