try { var energyMeterOneMachineStateHistory = Things["energyMeter1"].QueryNumberPropertyHistory({ oldestFirst: undefined /* BOOLEAN */ , maxItems: undefined /* NUMBER {"defaultValue":500} */ , propertyName: "ActivePower" /* STRING */ , endDate: undefined /* DATETIME */ , query: undefined /* QUERY */ , startDate: undefined /* DATETIME */ }); var energyMeterTwoMachineStateHistory = Things["energymeter2"].QueryNumberPropertyHistory({ oldestFirst: undefined /* BOOLEAN */ , maxItems: undefined /* NUMBER {"defaultValue":500} */ , propertyName: "ActivePower" /* STRING */ , endDate: undefined /* DATETIME */ , query: undefined /* QUERY */ , startDate: undefined /* DATETIME */ }); // // var energyMeterThreeMachineStateHistory = Things["energyMeter1"].QueryNumberPropertyHistory({ // oldestFirst: undefined /* BOOLEAN */ , // maxItems: undefined /* NUMBER {"defaultValue":500} */ , // propertyName: "MachinStatus" /* STRING */ , // endDate: undefined /* DATETIME */ , // query: undefined /* QUERY */ , // startDate: undefined /* DATETIME */ // }); energyMeterOneMachineStateHistory = Resources["InfoTableFunctions"].RenameField({ t: energyMeterOneMachineStateHistory, from: "value", to: "energyMeter1_ActivePower" }); energyMeterTwoMachineStateHistory = Resources["InfoTableFunctions"].RenameField({ t: energyMeterTwoMachineStateHistory, from: "value", to: "energyMeter2_ActivePower" }); // energyMeterThreeMachineStateHistory = Resources["InfoTableFunctions"].RenameField({ // t: energyMeterTwoMachineStateHistory, // from: "value", // to: "MachinStatus" // }); var params = { columns1: "*" /* STRING */ , columns2: "*" /* STRING */ , //columns3: "*" /* STRING */ , joinType: "FULL" /* STRING */ , t1: energyMeterOneMachineStateHistory /* INFOTABLE */ , t2: energyMeterTwoMachineStateHistory /* INFOTABLE */ , //t3: energyMeterThreeMachineStateHistory /* INFOTABLE */ , joinColumns1: "timestamp" /* STRING */ , joinColumns2: "timestamp" /* STRING */ , //joinColumns3: "timestamp" /* STRING */ }; // result: INFOTABLE result = Resources["InfoTableFunctions"].Intersect(params); } catch (err) { logger.info("OvensHistoricalData service error: " + err); logger.info("OvensHistoricalData service error: " + err.lineNumber); }