cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

Input date to refresh infotable

DD_7886593
2-Guest

Input date to refresh infotable

I have inserted two input date: startDate and endDate.

I have inserted this JS code in my service:

var params = {

    infoTableName : "InfoTable",

    dataShapeName : "TFPeopledata",

    startDate: startDate,

    endDate: endDate,

    maxItems: maxValues

};


var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);

for each(var row in res.rows){

            var newEntry = new Object();

            newEntry.People_in_region = row.People_in_region;

            newEntry.date_trunc = dateAddHours(row.date_trunc, -2); // DATETIME

            result.AddRow(newEntry);

}

The prob is don''t refresh with date selected.

Screenshot-2017-10-26 ThingWorx Composer(1).png

3 REPLIES 3

I don't see the query, but anyway, your code duplicates entries ( as you are iterating over result collection variable and in the loop you are adding to the same result collection variable ). This is Javascript code not Java code I'm right?

I have used a ValueStream for data storage

var res = Resources["CSVParserFunctions"].ReadCSVFile(params);

var maxValues = 100;

var oldFirst = false;

if(startDate != undefined){

    maxValues = 5000;

//    oldFirst = true;

}

var params = {

    oldestFirst: false /* BOOLEAN */,

    endDate: endDate /* DATETIME */,

    maxItems: maxValues /* NUMBER */,

    startDate: startDate /* DATETIME */

};

var history = me.QueryPropertyHistory(params);

var result = history;

var params = {

    infoTableName : "InfoTable",

    dataShapeName : "TFPeopledata",

    startDate: startDate,

    endDate: endDate,

    maxItems: maxValues

};

var result = Resources["InfoTableFunctions"].CreateInfoTableFromDataShape(params);

for each(var row in res.rows){

            var newEntry = new Object();

            newEntry.People_in_region = row.People_in_region;

            newEntry.date_trunc = dateAddHours(row.date_trunc, -2); // DATETIME

            result.AddRow(newEntry);

}


I got this as a result:
Results

timestamp

I think the prob with the data stream.

I don't know man, your code doesn't have much sense I'm sorry.

Top Tags