myQuery.columns = [ myQuery.createColumn({ fieldId: "custrecord_pay_start_date",groupBy: true, alias: 'startDate' }), myQuery.createColumn({ fieldId: "custrecord_pay_end_date",groupBy: true, alias: 'endDate' }), myQuery.createColumn({ fieldId: "custrecord_pay_empl",groupBy: true, alias: 'employee' }), myQuery.createColumn({ fieldId: "custrecord_pay_empl",groupBy: true, alias: 'employeeText', context: query.FieldContext.DISPLAY }), myQuery.createColumn({ fieldId: "custrecord_pay_amt",groupBy: true, alias: 'payAmount' }), timeBillJoin.createColumn({ fieldId: "custcol_proj_expense_acct", groupBy: true, alias: "expenseAccount", context: query.FieldContext.DISPLAY }), timeBillJoin.createColumn({ fieldId: "custcol_acct_cost_pool", groupBy: true, alias: "costPool", context: query.FieldContext.DISPLAY }), timeBillJoin.createColumn({ fieldId: "hours",groupBy: false, aggregate: query.Aggregate.SUM, alias: "costPool", context: query.FieldContext.DISPLAY }), employeeJoin.createColumn({ fieldId: "billingclass",groupBy: true, context: query.FieldContext.DISPLAY }), customerJoin.createColumn({ fieldId: "entitytitle",groupBy: true, context: query.FieldContext.RAW }), ];