Page History

This server class provides methods to operate database records.

SimpleRecord(tableName)

This method instantiates a 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 – containing information about the REM attributes. It is used to read and define edit REM attributes values of the current record with other class methods as in the example below.

Parameter:

Return:

Example:

const record = new SimpleRecord('task');
record.get('160638931615274614'); // Example record ID supposing to be extended with RE attributes 
// record.rem_attr - an object containing information about RE attributes

if (record.getReModelId()) {
    ss.info(record.rem_attr.description); // Here, we have called the RE attribute as a property
}

addOrCondition(property, operator, 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. In this method, you can use any preferred operator from the Condition Operators list, specified either in lowercase or in uppercase. Please notice Notice that you need to use the system name of the operator in your scripts.

Parameter(s):

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:

ExampleExamples:

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)

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. Please notice that you need to use system name of the operator in your scripts.

Parameter(s):

Return:

let record = new SimpleRecord('task');
record.addQuery('

Example:

const task = new SimpleRecord('task');
task.addQuery('active', true);
task.addQuery('subject', 'like', 'emailnot work');
taskrecord.addQueryaddOrCondition('sys_created_at166972638116358001:description', '<contains', '2019-04-01 00:00:00not work');
task.query();
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(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 

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:

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:

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:

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

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:

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

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:

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 deletes the current record.

Return:

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

Example:

const task = new SimpleRecord('task');
task.get('155931135900000000'addEncodedQuery(`subjectLIKE${subject}`);
const isDeleted = ss.info(task.deleteRecordgetConditionQuery());
iftry (isDeleted) {
    sstask.info('Task with ID ' + task.sys_id + ' was deleted!'query();
} catch else(e) {
    ss.error('Errors: ' + task.getErrors());
}

get(propertyOrValue, value)

e.message);
} 
// Info: (subjectLIKEHello, SimpleOne))
// Error: Condition query is invalid

Parameter(s):

Return:

Examples:

const current currentUser = ss.getUser();
const receiver = new SimpleRecord('taskemployee');
currentreceiver.getaddQuery('163663310116371174active', true);

if (current.sys_idcurrentUser.company.class === 'internal') {
    const company = new SimpleRecord('org_company'receiver.addEncodedQuery(`(company=${currentUser.getValue('company')})`);
} else {
   company receiver.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:

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 userRecordreceier = ss.getUser( new SimpleRecord('task');
receiver.addQuery('active', true);
receiver.addEncodedQuery('%28sys_db_table_id%3D158645243815904649%5E166972638116358001%3AdescriptionLIKEwork`);
ss.info(userRecord.getAttributes'Decoded condition: ' + receiver.getConditionQuery());
/receiver.query();
// Info: {"sys_id":"155931135900000001","sys_created_at":"2019-09-30 00:00:00","sys_updated_at":"2021-06-28...

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

canCreate()

This method returns the table title. If the title is not set, then returns namechecks 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:

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

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:

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:

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:

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:

Example:

const currentrecord = new SimpleRecord('tasksys_activity_feed_item');
currentrecord.getaddQuery('163663310116371174''content', 'isempty');
record.query();
ss.info(currentrecord.getDisplayValuegetRowCount('caller'));
ss.info(currentrecord.getValuedeleteMultiple('caller'));
// Info: John Doe0
// Info: 155931135900000001true

deleteRecord()

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:

---

This method deletes the current record.

Return:

Type	Description
Boolean	This method returns 'true' if the record is deleted successfully; otherwise it returns 'false'.

Example:

Code Block
language js theme Eclipse title deleteRecord

Example:

Code Block
language js theme Eclipse title getErrors linenumbers true
const recordtask = new SimpleRecord('task'); task.get('user155931135900000000'); 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: )",...

getLabel(property)  AnchorgetLabel()getLabel()

This method gets the field title.

Info The getLabel() method cannot be used with REM attributes. Instead, use the getTitle() method

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

Return:

Example:

Example:

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

getReModelId()

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

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

getRowCount()

This method gets the amount of items in a row.

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.

ReturnReturns:

Example:

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

getTableName()

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 = ss.getUser(new SimpleRecord('task');
current.get('163663310116371174');
ss.info('/list/' + current.getTableNamegetClassDisplayValue() + '/' + current.sys_id);
// Info: /list/user/155931135900000001

Task

getConditionQuery

()

This method returns

Parameter:

current query condition.

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

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

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

Parameter(s):

Return:

Example:

const current = ss.getUser(new SimpleRecord('task');
const user = new SimpleRecordcurrent.get('user163663310116371174');
userss.addQuery('timezone_id', info(current.getValuegetDisplayValue('timezone_idcaller'));
user.query();
ss.info('Same timezone for: ' + user.getRowCount() + ' users'current.getValue('caller'));
// Info: Same timezone for: 36 users

hasAttachment()

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:

Example:

const currentrecord = new SimpleRecord('taskuser');
current.get('163663310116371174');
const hasAttachinsertedRecordId = currentrecord.hasAttachmentinsert();
if (!hasAttachinsertedRecordId == 0) {
  ss.info(record.addErrorMessage('File should be attached');
  returngetErrors());
}
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.

// 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 taskRecordcurrent = new SimpleRecord('task');
ss.info(taskRecord.getAttributesgetUser().caller);
taskRecord.initialize(const fieldLabel = current.getLabel('username');
ss.info(taskRecord.getAttributes().calleraddErrorMessage('Field "' +  fieldLabel + '" cannot be blank');
// Info: 
// Info: 155931135900000001

insert()

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

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

This method gets the amount of items in a row.

Returns:

Example:

const tabletask = new SimpleRecord('sys_db_tabletask');
task.query();
ss.info(table.isTableVcsEnabledaddInfoMessage('All Tasks Count: ' + task.getRowCount());
// All Tasks InfoCount: true2

getTableName(

)

This method

gets the current

table name.

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

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

getTitle(attribute) 

Anchor
getTitle() getTitle()

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:

title of the defined RE attribute.

Parameter:

Return:

Example:

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: 100000000000000000Review completed

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.

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(Parameter(s):

Return:

const current = ss.getUser();
const firstLoguser = new SimpleRecord('sys_loguser');
firstLoguser.orderByaddQuery('sys_created_at'); // oldest record first
firstLog.addQuery('message', 'like', 'Connection');
firstLog.setLimit(1);
firstLog.selectAttributes(['message', 'sys_created_at']);
firstLog.query();
firstLog.nexttimezone_id', current.getValue('timezone_id'));
user.selectAttributes('sys_id');
user.query();
ss.info(firstLog.sys_created_atuser.getRowCount() + ' - ' + firstLog.messageusers have the same timezone as you');
// Info: 2021-06-03 06:34:02 - IMAP IMAP (Default): Connection error: ...

24 users have the same timezone as you

hasAttachment()

This method sorts the records in the descending order.

Parameter(s):

checks whether the record specified has an attachment or not.

Return:

Example:

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

query()

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

= 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 taskstaskRecord = new SimpleRecord('task');
tasksss.addQuery('sys_created_at', '>', '2020-01-01');
tasks.orderBy('sys_created_at');
tasks.setLimit(5);
tasks.queryinfo(taskRecord.getAttributes().caller);
taskRecord.initialize();
whiless.info(taskstaskRecord.nextgetAttributes().caller){
ss.info('Tasks numbers: ' +  tasks.number);
};
// Info: 
// RQTSK0000001, CHG0000004, CHG0000006, CHG0000007, CHG0000008

Info: 155931135900000001

insert()

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.

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 newTask

Do not use this method to select records that could be updated or deleted after selecting. Otherwise, some of the record field values may be lost when these records are updated or deleted. Or the action performed may throw an exception looking like this (the example text is given below):

Return:

This method returns a SimpleRecord object containing attributes and values.

Example:

const record = new SimpleRecord('usertask');
record.selectAttributes('email');
record.querynewTask.subject = 'Subtask';
const inserterTaskID = newTask.insert();
record.next();
ss.info(record.getAttributes())`/record/task/${inserterTaskID}`);
// Info: {"email":"john.doe@email.com","sys_id":"162423321917274937"}/record/task/163675231910113745

isTableVcsEnabled()

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

Return:

Example:

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

false

matchesCondition(condition)

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

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

Parameter(s):

Return:

const currenttask = new SimpleRecord('task');
current.get('163663310116371174');
const hasAttach = current.hasAttachment();
current.setAbortAction(!hasAttachtask.description = 'emaio';
ss.info(task.matchesCondition('descriptionLIKEemail')); // same as return;
current.statefalse
task.description = '2email'; // Open
current.update();

ss.info(task.matchesCondition('descriptionLIKEemail')); // true

next()

This method limits the number of records selected by SimpleRecord query methods.

Parameter(s):

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

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.

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.

Parameter(s):

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

Return:

Example:

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();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 lastComment = new 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(lastComment.sys_created_by.display_name + ': ' + lastComment.value);
// Info: John Doe: test

query()

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

Return:

Example:

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

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:

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"}

Example:

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"}

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

Parameter(s):

Return:

Example:

const record = new SimpleRecord('user');
record.setLimit(3);
record.query();
ss.info(record.getRowCount());
// Info: 3

setMultipleValue(property,value)

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

Parameter(s):

Return:

const task = new SimpleRecord('task');
task.addQuery('state', '7'); // Draft
task.query();
ss.info(task.getRowCount());
task.setMultipleValue('state', '2'); // 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 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();

Example:

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

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

update()

This method updates a database record.

Return:

Example:

const current = new SimpleRecord('taskuser');
current.get('undefined'(ss.getUserId());
current.subjecttimezone_id = 'Test156076775207670452'; // UTC
ss.info(current.update());
ss.info(current.getErrors());
// Info: 0155931135900000001
// Info: ["Invalid condition query: Use only digits","Unable to update new record. Use `insert()` instead. (record id: )"]

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