how to read an infotable having integer value

Question

Hello Community,I am getting the data in an infotable but i am unable to read it.  const SERVICENAME = "getPieChartDataOnMashup";
logger.info(me.name + " :: " + SERVICENAME + " :: Start Service");

let projectName = me.name.match(/^[^.]*/)[0];

let ab;
try {
 ab = Things["V2.MYSQLDatabaseController"].SQLQuery_GetEntriesForPieChart({
 
 lineName: lineName,
 StartDate:startDate,
 EndDate:endDate

});
 
 logger.info(ab.rows[0]);
 
} catch (e) {

logger.error("There is an error in service getPieChartDataOnMashup DataBase service.SQLQuery_GetEntriesForPieChart " + e);

}
 let result = ab; the below pic is for logger ab.rows[0] the below is the output of the service. i am unable to read in logger ioEntries like ab.rows[0].ioEntries the values is 0 but i am getting undefined. Why? i am getting this data from SQL query and i have set the ouput as an infotable with two fields of number.

MA8731174 · Accepted Answer

Hi @ZbigniewK and @Arun_C

Thanks both of you for your insights. Its actually spelling mistake and sometime thingworx needs to be refresh the service inorder to see effects but yeah its working now. Below is my code also. May be it will be useful for other people.

const SERVICENAME = "getPieChartDataOnMashup";
logger.info(me.name + " :: " + SERVICENAME + " :: Start Service");

let projectName = me.name.match(/^[^.]*/)[0];

let AnalysisInfotable = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape({
 infoTableName: "InfoTable",
 dataShapeName: "V2.Analysis.DS"
});

let queryresults;
try {
 queryresults = Things["V2.MYSQLDatabaseController"].SQLQuery_GetEntriesForPieChart({
 
 lineName: lineName,
 StartDate:startDate,
 EndDate:endDate

 });
// AnalysisInfotable.AddRow({Label:"ioEntries",Value:queryresults.rows[0].iOEntries});
// AnalysisInfotable.AddRow({Label:"nioEntries",Value:queryresults.rows[0].niOEntries});
 AnalysisInfotable.AddRow({Label:"ioEntries",Value:50});
 AnalysisInfotable.AddRow({Label:"nioEntries",Value:60});
 
 logger.info(queryresults.rows[0].iOEntries);
 
} catch (e) {

 logger.error("There is an error in service getPieChartDataOnMashup DataBase service.SQLQuery_GetEntriesForPieChart " + e);

}
 let result = AnalysisInfotable;

Do you guys know that how can i make infotable to show more then 500 rows. I am getting data from SQL query and its more then 500 but as the infotable only shows 500 rows. any idea how can i fetch more then 500? For datatable i know how to make it work with maxItems but i am not sure about infotable.

ZbigniewK · Answer

> i am unable to read in logger ioEntries like ab.rows[0].ioEntries
looks like spelling mistake, but you in logs you have iOEntries (low I, O in capital, E in capital, rest of text in low), but then you write ioEntries (O in low, not in capital).
Of course, if it's only mistake in your post, then do not care about my answer, but if it is also in your code - then I hope I helped you. Sometimes it's most difficult to notice such a small mistypes 🙂

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.

Scanning file for viruses.

This file cannot be downloaded