/**
* @NApiVersion 2.1
* @NScriptType UserEventScript
*/
define([‘N/query’],
/**
* @param{query} query
*/
(query) => {
/**
* Defines the function definition that is executed before record is loaded.
* @param {Object} scriptContext
* @param {Record} scriptContext.newRecord – New record
* @param {string} scriptContext.type – Trigger type; use values from the context.UserEventType enum
* @param {Form} scriptContext.form – Current form
* @param {ServletRequest} scriptContext.request – HTTP request information sent from the browser for a client action only.
* @since 2015.2
*/
const beforeLoad = (scriptContext) => {
try {
let query1 = query.create({
type: query.Type.TRANSACTION
});
let queryCond = query1.createCondition({
fieldId: ‘daysoverduesearch’,
operator: query.Operator.GREATER,
values: 10
})
query1.condition = queryCond;
query1.columns = [
query1.createColumn({
fieldId: ‘daysoverduesearch’,
}),
query1.createColumn({
fieldId: ‘id’
}),
query1.createColumn({
fieldId: ‘entity’
})
];
let resultSet = query1.run();
let results = resultSet.results
for(let i = results.length – 1;i>=0;i—)
{
log.debug(results[i])
}
} catch (e) {
log.error(“error”,e.message)
}
}
// /**
// * Defines the function definition that is executed before record is submitted.
// * @param {Object} scriptContext
// * @param {Record} scriptContext.newRecord – New record
// * @param {Record} scriptContext.oldRecord – Old record
// * @param {string} scriptContext.type – Trigger type; use values from the context.UserEventType enum
// * @since 2015.2
// */
// const beforeSubmit = (scriptContext) => {
// }
// /**
// * Defines the function definition that is executed after record is submitted.
// * @param {Object} scriptContext
// * @param {Record} scriptContext.newRecord – New record
// * @param {Record} scriptContext.oldRecord – Old record
// * @param {string} scriptContext.type – Trigger type; use values from the context.UserEventType enum
// * @since 2015.2
// */
// const afterSubmit = (scriptContext) => {
// }
return {beforeLoad}
});