Suite Deal
01/03/2022, 9:40 PM//Add Account Query for Grouping
var accountQuery = query.create({
type: 'customrecord_payments',
columns: [
{fieldId: 'custrecord_account',
context: {
name: query.FieldContext.DISPLAY
},
groupBy: true
},
{fieldId: 'custrecord_pay_type',
context: {
name: query.FieldContext.DISPLAY
},
groupBy: true
},
{fieldId: 'custrecord_pay_amount',
aggregate: query.Aggregate.SUM
}
]
});
accountQuery.sort = [
accountQuery.createSort({
column: accountQuery.columns[0]
}),
accountQuery.createSort({
column: accountQuery.columns[1],
})
];