To speed up the sampling generation, it is recommended to use the selectAttributes() method of the SimpleRecord class.
The example below generates an array containing IDs of the records:
selectAttributes
const user = new SimpleRecord('user');
user.addQuery('email', 'like', 'best.company');
user.selectAttributes('sys_id'); // select sys_id only
user.query();
const userIDs = [];
while (user.next()) {
userIDs.push(user.sys_id);
}
Add a records count preview before updating/deleting:
updateMultiple
const record = new SimpleRecord('sys_vcs_preview_log');
record.addQuery('retrieved_pack_id', current.sys_id);
record.addQuery('state', 'skipped');
record.addQuery('error_text', 'The system has a newer record');
record.query();
ss.addInfoMessage(`corrections for ${record.getRowCount()} objects`);
record.setMultipleValue('state', 'good');
//record.updateMultiple();
deleteMultiple
const record = new SimpleRecord('imp_ldap_users');
record.addEncodedQuery( `imp_company%3DSofaShop.ru^sys_created_atLIKE2019-`);
record.query();
ss.addInfoMessage(record.getRowCount());
//current.deleteMultiple();
Commentyour code when you use the Choice attributes in your scripts:
if (current.stage == '4' || current.stage == '6') { // Canceled OR Completed
const start = new SimpleDateTime(current.start_time);
//...
Use the getAttributes() method to check an object before inserting or updating: