Page History

This server class provides methods to operate the database records.

SimpleRecord(tableName)

This method instantiates a Use the constructor to instantiate an object of the SimpleRecord class object for a particular table.

Parameter(s):

Example:

const taskRecord = new SimpleRecord('task');

REM attribute object

The SimpleRecord class has a special object for Record Extended Models – rem_attr that contains information about the REM attributes. Used it Use it to read and edit REM attribute values of the current record with other class the methods as in the example shown below.

Parameter:

Return:

Example:

const record = new SimpleRecord('task');
record.get('160638931615274614');
if (record.getReModelId()) {
    ss.info(record.rem_attr.description);
}

addOrCondition(property, operator, value)

This method appends a 2-or-3 parameter OR a 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 Condition Operators list, specified either in lowercase or in uppercase. Notice that you need to use the system name of the operator in the scripts.

Parameter(s):

SimpleReference object

Anchor
SimpleReference SimpleReference

When you call the fields of the Reference type, the response contains a special SimpleReference object. This object allows you to access the fields of the record in the Reference field with dot-walking.

Example:

let

Return:

Example:

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

caller.getValue('username'));

addOrCondition(property, operator, value)

This method adds a condition to make a selection of records from the databaseUse the method to add the OR condition to an existing query. It works in conjunction with the addQuery() method. In this method, you can use any preferred necessary operator from the Condition Operators the condition operators list, specified either in lowercase lower- or in uppercase. Notice that you need to use Use the system name names of the operator operators in the 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)Parameter(s):

Return:

ExamplesExample:

const taskrecord = new SimpleRecord('task');
taskrecord.addQuery('activesubject', true);
task.addQuery('subject'like', 'like', 'emailnot 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 Countquery: 0

addEncodedQuery(condition)

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

Parameter(s):

Return:

 (subjectLIKEnot work)^OR(descriptionLIKEnot work)

Example:

constlet currentUserrecord = ss.getUser();
const reciever = new SimpleRecord('employeetask');
recieverrecord.addQuery('activesubject', true);
if (currentUser.company.class === 'internal') {
    reciever.addEncodedQuery(`(company=${currentUser.getValue('company')})`);
} else {
    reciever.addEncodedQuery(`%28sys_db_table_id%3D158645243815904649%5Esys_created_byDYNAMIC156957117519820256%29`);
}'like', 'not work')
record.addOrCondition('166972638116358001:description', 'contains', 'not work');
ss.info('DecodedCondition conditionquery: ' + recieverrecord.getConditionQuery());
recieverrecord.query();
// Info: DecodedCondition conditionquery: (active=1)^((sys_db_table_id=158645243815904649^sys_created_byDYNAMIC156957117519820256))

canCreate()

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

Also, use this method in the UI Actions to adjust its visibility more precisely.

Return:

subjectLIKEnot work)^OR(166972638116358001:descriptionLIKEnot work)

Example:

current.canCreate();

canDelete()

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

Also, use this method in the UI Actions to adjust its visibility more precisely.

Return:

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)

Use this method to add a condition to make a selection of records from the database. In this method, you can use any required operator from the condition operators list, specified in lower- or uppercase. Use the system names of the operators in the 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

Example:

current.canDelete();

canRead()

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

Also, use this method in the 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, use this method in the UI Actions to adjust its visibility more precisely.

Return:

Example:

current.canUpdate();

deleteMultiple()

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

Return:

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

Example:

const record = new SimpleRecord('sys_activity_feed_itemtask');
record.addQuery('content166972638116358001:description', 'isemptynot work');
record.query();
ss.info("Total rows: " + record.getRowCount());
ss.info(record.deleteMultiple());
// Info: 0
// InfoTotal rows: true1

deleteRecord()

This method deletes the current record.

Return:

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

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

A string value of a record ID or property name. If it is equal to the property name, the second parameter 'value' is mandatory.

// Info: Tasks count: 720

addEncodedQuery(condition) 

Anchor
addEncodedQuery addEncodedQuery

Use this method to add an encoded query to select records from the database. You can also use a decoded query.

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.

Return:

Example:

const subject = 'Hello, SimpleOne)';
const currenttask = new SimpleRecord('task');
currenttask.get('163663310116371174'addEncodedQuery(`subjectLIKE${subject}`);

if (current.sys_id)ss.info(task.getConditionQuery());
try {
    task.query();
} catch const company = new SimpleRecord('org_company'(e) {
   ss.error(e.message);
} 
// Info:  company.get('c_website', current.c_customer_url);
    ss.eventQueue('notify.responsible', current, company.responsible.email);
}

getAttributes()

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

Return:

(subjectLIKEHello, SimpleOne))
// Error: Condition query is invalid

Parameter(s):

Return:

Examples:

const userRecordcurrentUser = 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:

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

Example:

const currentreceier = new SimpleRecord('task');
currentreceiver.getaddQuery('163663310116371174''active', true);
receiver.addEncodedQuery('%28sys_db_table_id%3D158645243815904649%5E166972638116358001%3AdescriptionLIKEwork`);
ss.info(current.getClassDisplayValue'Decoded condition: ' + receiver.getConditionQuery());
receiver.query();
// Info: Task

Decoded condition: (active=1)^((sys_db_table_id=158645243815904649^166972638116358001:descriptionLIKEwork))

canCreate()

Use this method to check whether the current user can create records in the specified table according to the Access Control Rule (ACL).

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:

current.canCreate();

canDelete()

Use the method to check whether the current user can delete records in the specified table according to the Access Control Rule (ACL).

Return:

Example:

current.canDelete();

canRead()

Use the method to check whether the current user can read records in the specified table according to the Access Control Rule (ACL).

Return:

Example:

current.canRead();

canUpdate()

Use this method to check whether the current user can edit records in the specified table according to the Access Control Rule (ACL).

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

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.

Some validation errors may not be displayed within the debug process, so it is highly recommended to use this method.

current.canUpdate();

deleteMultiple()

Use this method to delete multiple records form the selection. The attachments of the deleted records are not deleted.

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

Use this method to delete a record.

When the method is called in a selection of records with the parameter set, the record with a specific ID is deleted. If id in not specified in the parameter, the method deletes the current record.

Parameter:

Return:

Example:

const recordtask = new SimpleRecord('task');
task.get('user');155931135900000000');
if (!task.sys_id) {
  return;
}
const insertedRecordIdisDeleted = recordtask.insertdeleteRecord();
if (insertedRecordId == 0isDeleted) {
  ss.info(record.getErrors());
}
// Info: ["The \"\"First Name\" [first_name]\" field is mandatory. (record id: )",...

'Task with ID ' + task.sys_id + ' was deleted!');
  return;
}
ss.error(task.getErrors());

get(propertyOrValue, value)

Use this method to load an object from a database by the field value, or, in a specific case, by the ID. The propertyOrValue parameter is the ID value of the record or the property name. If the value is the property name, the value parameter is mandatory.

Parameter(s

This method gets the field title.

Parameter(s):

Return:

Example:

const current = ss.getUser();
const fieldLabel = current.getLabel('usernamenew SimpleRecord('task');
sscurrent.addErrorMessageget('Field "' +  fieldLabel + '" cannot be blank');
// Field "Login" cannot be blank

This method retrieves the ID of the RE model related to the current record. To set a new model ID use the setReModelId method.

Return:

String

163663310116371174');

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'; // 

getRowCount()

This method gets the amount of items in a row.

English
ss.info(user.update());
// Info: 167515292501757147

getAttributes()

Use the method to return an object with the current record attributes as the keys and key values.

ReturnReturns:

Example:

const taskuserRecord = new SimpleRecord('task');
task.queryss.getUser();
ss.addInfoMessage('All Tasks Count: ' + task.getRowCountinfo(userRecord.getAttributes());
// All Tasks Count: 2

getTableName()

This method gets the current table name.

Return:

Info: {"sys_id":"155931135900000001","sys_created_at":"2019-09-30 00:00:00","sys_updated_at":"2021-06-28...

getClassDisplayValue()

Use this method to return the title of the current table. 

Return:

Example:

const current = ss.getUser( new SimpleRecord('task');
current.get('163663310116371174');
ss.info('/list/' + current.getTableNamegetClassDisplayValue() + '/' + current.sys_id););
// Info: /list/user/155931135900000001

Task

getConditionQuery()

Use this method to return the current query condition.

This method returns the title of the defined RE attribute.

Parameter:

Return:

Example:

const currenttask = new SimpleRecord('task');
current.getconst condition = task.addQuery('163638951512716126state', '7');
if (current.sys_id) {
    ss.info(current.rem_attr.getTitle('reviewed'));
}condition.addOrCondition('priority', '<', '3');
ss.info('Condition before query: ' + task.getConditionQuery());
task.query();
ss.info('Condition after query: ' + task.getConditionQuery());
// Info: Review completed

 Condition before query: (state=7)^OR(priority<3)
// Info: Condition after query:

getDisplayValue(property) 

Anchor

getDisplayValue()

getDisplayValue()

Use this method

to return the displayed value of the

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

record parameter. For example, for the Reference field the record name is returned, not the ID.

With no parameter specified, the method returns the display value of the record from the field with the Display by ref checkbox selected.

To speed up the script execution, use this method to get values of the fields of the Reference type instead of Dot-walking.

Find the values represented in the server scripts according to the field types in the table.

Parameter(s):

Return:

Example:

const current = ss.getUser();
const user = new SimpleRecord('usertask');
user.addQuery('timezone_id', current.getValueget('timezone_id163663310116371174'));
user.selectAttributesss.info(current.getDisplayValue('sys_idcaller');
user.query();
ss.info(usercurrent.getRowCountgetValue() + ' users have the same timezone as you''caller'));
// Info: 24 users have the same timezone as you

hasAttachment()

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

Return:

John Doe
// Info: 155931135900000001

getErrors() 

Anchor
getErrors() getErrors()

Use this method to get an error message in case of failure of a record creating, updating or deleting. 

Use this method to control the execution of an operation with a record in a script.

Return:

Example:

Example:

const currentrecord = new SimpleRecord('taskuser');
current.get('163663310116371174');
const hasAttachinsertedRecordId = currentrecord.hasAttachmentinsert();
if (!hasAttachinsertedRecordId == 0) {
  ss.info(record.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:

getErrors());
}
// Info: ["The \"\"Login\" [username]\" field is mandatory. (record id: )",...

getLabel(property) 

Anchor
getLabel() getLabel()

Use this method to get the field title.

Parameter(s):

Return:

Example:

Example:

const taskRecordcurrent = new SimpleRecord('task');
ss.info(taskRecord.getAttributesgetUser().caller);
taskRecord.initialize(const fieldLabel = current.getLabel('username');
ss.info(taskRecord.getAttributes().caller)addErrorMessage('Field "' +  fieldLabel + '" cannot be blank');
// Info: 
// Info: 155931135900000001

insert()

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

Field "Login" cannot be blank

getReModelId() 

Anchor
getremodelid getremodelid

Use this method to retrieve the ID of the RE model related to the current record. To set a new model ID use the setReModelId methodIf 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 newTask(function executeRule(current, previous = new SimpleRecord('task');
newTask.subject = 'Subtask';
const inserterTaskID = newTask.insert();
ss.info(`/record/task/${inserterTaskID}`);
// Info: /record/task/163675231910113745

isTableVcsEnabled()

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

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

getRowCount()

Use this method to get the number of the items in a selection.

Returns:

Example:

const currenttask = new SimpleRecord('usertask');
ss.info(current.isTableVcsEnabledtask.query());
// Info: false

matchesCondition(condition)

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

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

getTableName()

Use this method to get the name of the current table.

Return:

Example:

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

next()

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

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

getTitle(attribute) 

Anchor
getTitle() getTitle()

Use this method to get the title of the defined RE attribute.

Parameter:

Return:

Example:

Until the method is called, the values of a SimpleRecord object are not available, and the 'Current record is not set' message will occur. Consider the example:

const usercurrent = new SimpleRecord('usertask');
usercurrent.setLimitget(1'163638951512716126');
user.query();
user.next();
if (current.sys_id) {
    ss.info(usercurrent.sys_idrem_attr.getTitle('reviewed'));
}
// 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 sorts records in the ascending order.

Return:

 Review completed
const 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()

Use this method to return the value of the specified object attribute.

If the field is of the Reference or List types, the method returns its IDvalue.

Find the values represented in the server scripts according to the other field types in the table.

Parameter(s):

Return:

Example:

const current = ss.getUser();
const user = new SimpleRecord('user');
user.addQuery('timezone_id', current.getValue('timezone_id'));
user.selectAttributes('sys_id');
user.query

Example:

const 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_atuser.getRowCount() + ' - ' + firstLog.message users have the same timezone as you');
// 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):

 24 users have the same timezone as you

hasAttachment()

Use this method to check whether the specified record has an attachment or not.

const lastCommentcurrent = new SimpleRecord('sys_activities_stream_fieldtask');
lastCommentcurrent.orderByDescget('sys_created_at163663310116371174');
const //hasAttach newest record first
lastComment.setLimit(1= current.hasAttachment();
lastComment.selectAttributes(['value', 'sys_created_by']);
lastComment.query();
lastComment.next();
ss.info(lastComment.sys_created_by.display_name + ': ' + lastComment.value);
// Info: John Doe: test

if (!hasAttach) {
  ss.addErrorMessage('File should be attached');
  return;
}
current.state = '2'; // Open
current.update();

const taskstaskRecord = new SimpleRecord('task');
tasks.addQuery('sys_created_at', '>', '2020-01-01'ss.info(taskRecord.getAttributes().caller);
taskstaskRecord.orderBy('sys_created_at');
tasks.setLimit(2);
tasks.query();
while (tasks.next()) {
  ss.info('Task number: ' +  tasks.number);
}initialize();
ss.info(taskRecord.getAttributes().caller);
// Info: Task number: TSK0000001
// Info: Task number: TSK0000003

155931135900000001

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

const recordcurrent = new SimpleRecord('user');
record.selectAttributes('email');
record.query();
record.next();
ss.info(recordcurrent.getAttributesisTableVcsEnabled());
// Info: {"email":"john.doe@email.com","sys_id":"162423321917274937"}false

const recordtask = new SimpleRecord('usertask');
record.selectAttributes(['email',task.description = 'usernameemaio']);
record.query();
record.next()ss.info(task.matchesCondition('descriptionLIKEemail')); // false
task.description = 'email';
ss.info(recordtask.getAttributesmatchesCondition('descriptionLIKEemail'));
 // Info: {"email":"john.doe@email.com","username":"john.doe","sys_id":"162423321917274937"}

true

const currentuser = new SimpleRecord('taskuser');
currentuser.getsetLimit('163663310116371174'1);
const hasAttach = current.hasAttachmentuser.query();
if (!hasAttach) {
    ss.addErrorMessage('File should be attached!');
    current.setAbortAction(true);
}
current.state = '2'; // Open
current.update();

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

const recordfirstLog = new SimpleRecord('usersys_log');
firstLog.orderBy('sys_created_at'); // oldest record first
firstLog.addQuery('message', 'like', 'Connection');
firstLog.setLimit(31);
recordfirstLog.query(selectAttributes(['message', 'sys_created_at']);
ssfirstLog.info(record.getRowCountquery();
firstLog.next());
// Info: 3

;
ss.info(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');
tasklastComment.addQueryorderByDesc('state', '7sys_created_at'); // newest record Draftfirst
tasklastComment.querysetLimit(1);
sslastComment.info(task.getRowCount());
task.setMultipleValue('stateselectAttributes(['value', '2'); // Open
// task.updateMultiple();

sys_created_by']);
lastComment.query();
lastComment.next();
ss.info(lastComment.sys_created_by.display_name + ': ' + lastComment.value);
// Info: John Doe: Test comment

const task = new SimpleRecord('task');
task.get('163352033916904699');
if (task.getValue('service') === '164069027812962298') { // Email Server Service
    task.setReModelId('158569205818704980'); // Email Server Access Request
} else {
    task.setReModelId(null);
}
task.update();

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 = new SimpleRecord('user');
record.selectAttributes('email');
record.query();
record.next();
ss.info(record.getAttributes());
// Info: {"email":"john.doe@email.com","sys_id":"162423321917274937"}

const record = new SimpleRecord('user');
record.selectAttributes(['email', 'username']);
record.query();
record.next();
ss.info(record.getAttributes());
// Info: {"email":"john.doe@email.com","username":"john.doe","sys_id":"162423321917274937"}

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 record = new SimpleRecord('user');
record.setLimit(3);
record.query();
ss.info(record.getRowCount());
// Info: 3

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.get('163352033916904699');
if (task.getValue('service') === '164069027812962298') { // Email Server Service
    task.setReModelId('158569205818704980'); // Email Server Access Request
} else {
    task.setReModelId(null);
}
task.update();

(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', 'isempty');
task.query();
ss.info(task.getRowCount());
task.silentMode();
task.setMultipleValue('approval_state', 'not_requested'); // set Default value Value
//task.updateMultiple();

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