Skip to main content
16-Pearl
August 16, 2022
Question

Aggregate function is not generating result in js service

  • August 16, 2022
  • 1 reply
  • 659 views

partResult = Things["SmartParts.DataBaseSystem-TH"].GetWhereUsedImmediateParent({
COMPONENT_ITEMNUMBER: PartNumber /* STRING */
});

let sum = Resources["InfoTableFunctions"].CreateInfoTable();
logger.debug("GetWhereUsedImmediateParent: sum IT length is "+sum.length);
//sum.AddField({name: "Sum", baseType: "NUMBER"});
let params = {
t: partResult /* INFOTABLE */,
columns: "_12_Month_FORECASTED_USAGE" /* STRING */,
aggregates: "SUM" /* STRING */
};
result = Resources["InfoTableFunctions"].Aggregate(params);

1 reply

17-Peridot
August 17, 2022
  1. Got any error message while executing this service?
  2. Ensure the minimum 1 record available in 'partResult' infotable.
  3. Ensure '_12_Month_FORECASTED_USAGE' field is available in 'partResult' infotable.