Community Tip - You can Bookmark boards, posts or articles that you'd like to access again easily! X
I want to fetch all records from the value stream. Value stream stores the 86400 records in one day. I used the QueryPropertyHistory() which gives me only 500 rows and if I define maxItems(Data points of 3 days) it gives me a script timeout error and I want to show this on the line chart. Or is there any limit to showing data points on a line chart?
Solved! Go to Solution.
Hi @NF_10758894
Please refer to this community post - Display last 3month data from valuestream on time ... - PTC Community
You can create a logic to fetch data every hour and merge it using the Union Function in Thingworx. For example: If the startDate and endDate difference is 3 days, instead of fetching 259200 rows of data you can fetch hourly data (7200 rows) by altering startDate and endDate through service. And merge infoTable and return output.
/VR
Hi @NF_10758894
Please refer to this community post - Display last 3month data from valuestream on time ... - PTC Community
You can create a logic to fetch data every hour and merge it using the Union Function in Thingworx. For example: If the startDate and endDate difference is 3 days, instead of fetching 259200 rows of data you can fetch hourly data (7200 rows) by altering startDate and endDate through service. And merge infoTable and return output.
/VR