Page History

This server class provides methods to operate with database records.

SimpleRecord(tableName)

Instantiates This method instantiates a SimpleRecord class object for the a particular table specified.

Parameter(s):

Example:

const tasktaskRecord = new SimpleRecord('task');

addOrCondition(property, operatorOrValue, value)

This method appends a 2-or-3 parameter OR condition to an existing query. It works in conjunction with any of the addQuery() methods.

REM attribute object

The SimpleRecord class has a special object for Record Extended Models – rem_attr – containing information about the REM attributes. It is used to read and edit REM attributes values of the current record with other class methods as in the example below.

ParameterParameter(s):

Return:

Return:

Example:

const taskrecord = new SimpleRecord('task');
taskrecord.addQueryget('subject', 'like', 'email').addOrCondition('description', 'like', 'email');
task.query();

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

addOrCondition(property, operator, value)

This method adds a condition for the selection from the databaseappends a 2-or-3 parameter OR condition to an existing query. It works in conjunction with any of the addQuery() methods. In this method, you can use any preferred operator from the the Condition Operators list list, specified either in lowercase or in uppercase.

Parameter(s):

Notice that you need to use the system name of the operator in your scripts.

You can also specify a RE model attribute of a specific table. To filter records, use the operators corresponding to the attribute type.

Parameter(s):

Return:

Examples:

const record = new SimpleRecord('task');
record.addQuery('subject', 'like', 'not work')
record.addOrCondition('description', 'like', 'not work');
ss.info('Condition query: ' + record.getConditionQuery());
record.query();
// Info: Condition query: (subjectLIKEnot work)^OR(descriptionLIKEnot work)

let record = new SimpleRecord('task');
record.addQuery('subject', 'like', 'not work')
record.addOrCondition('166972638116358001:description', 'contains', 'not work');
ss.info('Condition query: ' + record.getConditionQuery());
record.query();
// Info: Condition query: (subjectLIKEnot work)^OR(166972638116358001:descriptionLIKEnot work)

const task = new SimpleRecord('task');
task.setLimit(1);
task.query();
if (!task.next()) {
  ss.info('No tasks found!');
  return;
}

const relatedTask = new SimpleRecord('task');
relatedTask.addQuery('caller', task.caller);
relatedTask.addOrCondition('assigned_user', task.caller);
relatedTask.query();
ss.info('Tasks count: ' + relatedTask.getRowCount());
// Info: Tasks count: 122

addQuery(property, operator, value)

This method adds a condition to make a selection of records from the database. In this method, you can use any preferred operator from the Condition Operators list, specified either in lowercase or in uppercase. Note that you need to use system name of the operator in your scripts.

You can also specify a RE model attribute of a specific table. To filter records, use the operators corresponding to the attribute type. 

Parameter(s):

Return:

Examples:

const task = new SimpleRecord('task');
task.addQuery('active', true);
task.addQuery('subject', 'like', 'email');
task.addQuery('sys_created_at', '<', '2019-04-01 00:00:00');
task.query();
ss.info('Count: ' + task.getRowCount());
// Info: Count: 0

let record = new SimpleRecord('task');
record.addQuery('166972638116358001:description', 'not work');
record.query();
ss.info("Total rows: " + record.getRowCount());
// Info: Total rows: 1

const task = new SimpleRecord('task');
task.setLimit(1);
task.query();
if (!task.next()) {
  ss.info('No tasks found!');
  return;
}

const otherTask = new SimpleRecord('task');
otherTask.addQuery('caller', task.caller);
otherTask.addQuery('sys_id', '!=', task.sys_id);
otherTask.query();
ss.info('Tasks count: ' + otherTask.getRowCount());
// Info: Tasks count: 720

addEncodedQuery(condition)

This method adds encoded query and applies it to the current query method.

You can also specify a RE model attribute of a specific table. To filter records, use the operators corresponding to the attribute type. 

Use curly brackets when setting a filter argument for the text fields of type String, Text, Translated Text, Conditions, and URL. Using parenthesis for the argument may cause a filter query error.

const subject = 'Hello, SimpleOne)';
const task = new SimpleRecord('task');
task.addEncodedQuery(`subjectLIKE${subject}`);
ss.info(task.getConditionQuery());
try {
    task.query();
} catch (e) {
   ss.error(e.message);
} 
// Info: (subjectLIKEHello, SimpleOne))
// Error: Condition query is invalid

Parameter(s):

Return:

Examples:

const currentUser = ss.getUser();
const receiver = new SimpleRecord('employee');
receiver.addQuery('active', true);
if (currentUser.company.class === 'internal') {
    receiver.addEncodedQuery(`(company=${currentUser.getValue('company')})`);
} else {
    receiver.addEncodedQuery(`%28sys_db_table_id%3D158645243815904649%5Esys_created_byDYNAMIC156957117519820256%29`);
}
ss.info('Decoded condition: ' + receiver.getConditionQuery());
receiver.query();
// Info: Decoded condition: (active=1)^((sys_db_table_id=158645243815904649^sys_created_byDYNAMIC156957117519820256))

const receier = new SimpleRecord('task');
receiver.addQuery('active', true);
receiver.addEncodedQuery('%28sys_db_table_id%3D158645243815904649%5E166972638116358001%3AdescriptionLIKEwork`);
ss.info('Decoded condition: ' + receiver.getConditionQuery());
receiver.query();
// Info: Decoded condition: (active=1)^((sys_db_table_id=158645243815904649^166972638116358001:descriptionLIKEwork))

canCreate()

This method checks whether inserting new records in this table satisfies the Access Control Rule (ACL).

Also, you can use this method in your UI Actions to adjust its visibility more precisely.

Return:

Example:

current.canCreate();

canDelete()

This method checks whether deleting records in this table satisfies the Access Control Rule (ACL).

Also, you can use this method in your UI Actions to adjust its visibility more precisely.

Return:

Example:

current.canDelete();

canRead()

This method checks whether reading records in this table satisfies the Access Control Rule (ACL).

Also, you can use this method in your UI Actions to adjust its visibility more precisely.

Return:

Example:

current.canRead();

canUpdate()

This method checks whether updating records in this table satisfies the Access Control Rule (ACL).

Also, you can use this method in your UI Actions to adjust its visibility more precisely.

Return:

Example:

current.canUpdate();

deleteMultiple()

This method allows deleting multiple records in a query selection. Please note that attachments cannot be deleted using this method.

Return:

Example:

const record = new SimpleRecord('sys_activity_feed_item');
record.addQuery('content', 'isempty');
record.query();
ss.info(record.getRowCount());
ss.info(record.deleteMultiple());
// Info: 0
// Info: true

deleteRecord()

This method deletes the current record.

Return:

Example:

const task = new SimpleRecord('task');
task.get('155931135900000000');
if (!task.sys_id) {
  return;
}
const isDeleted = task.deleteRecord();
if (isDeleted) {
  ss.info('Task with ID ' + task.sys_id + ' was deleted!');
  return;
}
ss.error(task.getErrors());

get(propertyOrValue, value)

This method loads an object from a database by the field value, or, in a specific case, by the sys_id.

Parameter(s):

Return:

Example:

const task = new SimpleRecord('task');
task.get('163663310116371174'); // get by ID

if (task.state == '18') { // Rejected
  const company = new SimpleRecord('org_company');
  company.get('c_website', task.c_customer_url); // get by Customer URL
  ss.eventQueue('notify.responsible', task, company.responsible.email);
}

const task = new SimpleRecord('task');
task.setLimit(1);
task.query();
if (!task.next()) {
  ss.info('No tasks found!');
  return;
}

const user = new SimpleRecord('user');
user.get(task.caller);
user.language_id = '156628684306541141'; // English
ss.info(user.update());
// Info: 167515292501757147

getAttributes()

This method returns an object with current record properties as keys and properties values as key values.

Return:

const userRecord = ss.getUser();
ss.info(userRecord.getAttributes());
// Info: {"sys_id":"155931135900000001","sys_created_at":"2019-09-30 00:00:00","sys_updated_at":"2021-06-28...

getClassDisplayValue()

This method returns the table title. If the title is not set, then returns name.

Return:

Example:

const current = new SimpleRecord('task');
current.get('163663310116371174');
ss.info(current.getClassDisplayValue());
// Info: Task

getConditionQuery()

This method returns current query condition.

Return:

Example:

const task = new SimpleRecord('task');
const condition = task.addQuery('state', '7');
condition.addOrCondition('priority', '<', '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:

getDisplayValue(property) 

Anchor
getDisplayValue() getDisplayValue()

This method returns the value of display_by_ref field or record value. For example, for the reference field the entity name will be returned, but not the ID.

Parameter(s):

Return:

Example:

const current = new SimpleRecord('task');
current.get('163663310116371174');
ss.info(current.getDisplayValue('caller'));
ss.info(current.getValue('caller'));
// Info: John Doe
// Info: 155931135900000001

getErrors() 

Anchor
getErrors getErrors

If the record creating, updating or deleting fails, then this method will display an error message.

Use this method for control purposes if there any validation errors within your scripts.

Return:

Return:

Example:

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

addEncodedQuery(condition)

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

getLabel(property) 

Anchor
getLabel() getLabel()

This method gets the field title.

Parameter(s):

Return:

Example:

const taskcurrent = new SimpleRecord('task ss.getUser();
const fieldLabel = current.getLabel('username');
task.addEncodedQuery('active=1');

canCreate()

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

getReModelId() 

Anchor
getremodelid getremodelid

This method retrieves the ID of the RE model related to the current record. To set a new model ID use the setReModelId methodThis method determines if the Access Control Rules permit inserting new records in this table.

Return:

Example:

const task = new SimpleRecord('task');
ss.info(task.canCreate());

canDelete()

This method determines if the Access Control Rules permit deleting records in this table.

Return:

Example:

const task(function executeRule(current, previous = null /*not null only when action is update*/) {
    if (current.getReModelId()) {
        const model = new SimpleRecord('tasksys_rmc_model');
task        model.get('155964310500000194')
ss.info(task.canDelete());

canRead()

This method determines if the Access Control Rules permit reading records in this table.

Return:

current.getReModelId()); // current model
        current.$$service = model.getValue('cmdb_service_id'); // pass service if field exists
    }
})(current, previous);

getRowCount()

This method gets the amount of items in a row.

Returns

Example:

const task = new SimpleRecord('task');
task.get('155964310500000194');
ss.info(task.canRead());

canUpdate()

This method determines if the Access Control Rules permit updating records in this table.

:

Example:

const task = new SimpleRecord('task');
task.get('155964310500000194');
ss.info(task.canUpdate());

deleteMultiple()

This method allows deleting multiple records that meet the query condition. It does not allow deleting attachments.

Do not use it on tables with dependencies. Always delete each record individually.

Also, do not use it combined with the setLimit() method when working with large tables.

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

getTableName()

This method gets the current table name.

Return:

Example:

const messagecurrent = new SimpleRecord('message'ss.getUser();
messagess.addQueryinfo('value', 'like', 'network');
message.query();
message.deleteMultiple();

deleteRecord(recordSetId)

This method deletes the current record.

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

getTitle(attribute) 

Anchor
getTitle() getTitle()

This method returns the title of the defined RE attribute.

ParameterParameter(s):

Return:

Example:

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

get(propertyOrValue, value)

This method loads an object from a database based on the field value, or, in a specific case, by the sys_id.

Parameter(s):

Return:

Example:

const incident = new SimpleRecord('itsm_incident');
incident.get('subject', 'Network does not work');

getAttributes()

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

getValue(property) 

Anchor
getValue() getValue()

This method returns the value of the object property based on its name.

If the field is of the Reference or List types, then its sys_id value returns.

Parameter(s):

Return:

const current = ss.getUser();
const tableuser = new SimpleRecord('user');
user.addQuery('timezone_id', current.getValue('timezone_id'));
user.selectAttributes('sys_db_table'id');
user.query();
table.get('155931135900000015');
print(JSON.stringify(table.getAttributes()))ss.info(user.getRowCount() + ' users have the same timezone as you');
// {"sys_id":"155931135900000015","parent_id":"","sys_number_id":"","name":"sys_db_table","...

getClassDisplayValue()

Info: 24 users have the same timezone as you

hasAttachment()

This method checks whether the record specified has an attachment or notThis method returns the table title. If the title is not set, then returns name.

Return:

Example:

const task = new SimpleRecord('task');
ss.info(task.getClassDisplayValue()); // Task

getConditionQuery()

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

initialize()

This method populates all active empty fields with their predefined default values.

It works only for new records that were never saved and cannot be called repeatedly.

This method is called automatically and implicitly at the first set operation (also known as "the setter").

Return:

Example:

const tasktaskRecord = new SimpleRecord('task');
const condition = task.addQuery('state', '-2');
condition.addOrCondition('state', '0');
condition.addOrCondition('state', '7');
task.nextss.info(taskRecord.getAttributes().caller);
taskRecord.initialize();
ss.info(tasktaskRecord.getConditionQuerygetAttributes().caller);
// Info: 
// ((state=-2)^OR(state=0))^OR(state=7)

 Info: 155931135900000001

insert()

This method returns displayed field or record value (the display_by_ref field). For example, for the reference field the entity name will be returned, but not the ID.

Parameter(s):

Return:

uses the field values of the current record to insert a new one.

If the record is not inserted then method returns '0' (zero) and adds an informative error message which can be obtained with getErrors() method.

Return:

Example:

const incidentnewTask = new SimpleRecord('itsm_incidenttask');
incident.get('150000000000000001'newTask.subject = 'Subtask';
const inserterTaskID = newTask.insert();
ss.info(incident.getDisplayValue('caller'));

getErrors()

`/record/task/${inserterTaskID}`);
// Info: /record/task/163675231910113745

isTableVcsEnabled()

This method checks whether the VCS enabled attribute is enabled against the specified table or not. 

Return:

Example:

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

getLabel(property)

This method returns the field title.

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

matchesCondition(condition)

This method checks whether the current record meets the condition in the current state.Parameter(s):

Return:

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

next()

This

Returns:

method returns the next record in the query. If this is the first call, this method returns the first record in query. If the query is empty, this method returns 'false'.

Return:

Example:

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

getTableName()

This method returns the current table name.

Return:

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

const 

task = new SimpleRecord('

task');
task.setLimit(1);
task.query();
// task.next();
ss.info(

task.

number)

;

//

 Error: Current record is not set.

orderBy(column)

This method returns the value of the object property based on its name.If the field is of the Reference or List types, then its sys_id value returnssorts records in the ascending order.

Parameter(s):

Return:

Example:

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

hasAttachment()

This method checks whether the record specified has an attachment or not.

 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: ...

orderByDesc(column)

This method sorts the records in the descending order.

Parameter(s):

Return:

Example:

const tasklastComment = new SimpleRecord('task');
task.get('157531598110402540'('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

query()

This method

It works only for new records that were never saved and cannot be called repeatedly.

applies query to the database selection. After this, it fills in the record set.

Return:

Example:

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('')));

insert()

This method inserts a new record using the field values set for the current record.

If the record is not inserted then method returns '0' (zero) and adds an informative error message which can be obtained with getErrors() method.

Return:

• If validation errors occurred and record was not updated, then method returns '0' and you can get a message containing list of errors.
• As a normal case, a unique ID of the inserted record returns.

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

selectAttributes(attributes)

This method is intended to optimize database queries. Sometimes, it is necessary to obtain only several object fields, not the whole object. Therefore, this method was added.

Return:

Example:

Example:

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

isTableVcsEnabled()

This method checks whether the VCS enabled attribute is enabled against the table specified or not. 

Return:

Example:

const table = new SimpleRecord('sys_db_table');
ss.info(table.isTableVcsEnabled()); // true

matchesCondition(condition)

This method checks whether the current record meets the condition being in the current state.

Return:

const taskrecord = new SimpleRecord('taskuser');
rec.description = 'dsc';
ss.info(rec.matchesCondition('descriptionLIKEesc')); // false
rec.description = 'desc'record.selectAttributes('email');
record.query();
record.next();
ss.info(recrecord.matchesConditiongetAttributes('descriptionLIKEesc')); // true

next()

If this is a new request, then this method returns the first record from the list; otherwise it returns FALSE, in the case if the record is unavailable.

Return:

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

Example:

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

orderBy(column)

This method sorts records in the ascending order.

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

setAbortAction(flag)

This method is used in business rules and sets a flag, indicating that the current operation (insert/update/delete) will be interrupted.

Parameter(s):

Return:

Example:

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

orderByDesc(column)

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

setLimit(maxNumRecords)

This method limits the number of records selected by SimpleRecord query methodsThis method sorts the records in the descending order.

Parameter(s):

Return:

Example:

const incidentrecord = new SimpleRecord('itsm_incidentuser');
incidentrecord.orderByDesc('sys_updated_at'setLimit(3);
incidentrecord.query();

query()

This method runs a query against the selection from the database, based on the $this→query. After this, it fills in the record set.

Return:

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

setMultipleValue(property,value)

This method sets the properties values for every entry in the current selection.

Parameter(s):

selectAttributes(attributes)

This method is intended to optimize database queries. Sometimes, it is necessary to obtain only several object fields, not the whole object, Therefore, this method is added.

Return:

Example:

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

setReModelId(reModelId) 

Anchor
setremodelid setremodelid

This method sets the ID of the defined RE model. To get the model ID, use the getReModelId method.

Parameter(s):

If the reModelId parameter is equal to 'null', the REM, related to the record, will be detached. 

Return:

Example:

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 || 'nulltask');
task.get('163352033916904699');
if (task.getValue('service') === '164069027812962298') { // Email Server Service
    task.setReModelId('158569205818704980'); // null
  // other fields are null
}

setAbortAction(flag)

This method sets a flag, indicating that will be current operation (insert/update/delete) interrupted. It used in business rules.

Parameter(s):

Return:

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

Example:

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

setLimit(maxNumRecords)

Sets a limit for a number of records are fetched by SimpleRecord query.

Parameter(s):

Return:

Example:

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

setMultipleValue(property,value)

This method sets the properties values for every entry in the current selection.

Parameter(s):

Return:

This method does not return a value.

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

setValue(property, value) 

Anchor
setValue() setValue(

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

)

This method sets the value of the field in the current record.

Parameter(s):

Return:

Example:

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

silentMode(enable)

This method is intended to update the record without executing any entities related to this record implementing the business logic, such as business rules, notifications, workflows, etc.

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.updatesetMultipleValue('approval_state', 'not_requested'); // set Default Value
//task.updateMultiple();

update()

This method updates a database record. record.

Return:

Example:

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: []

updateMultiple()

This method updates all the selection entries.

Return:

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