Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. X
I want to create a data table in which I want keep record of orders. My data table contains information like name, status, price etc. I want to extract data having status delivered and find the total sum of those order and display it on a label display widget but I can't find a good documentation related to this if some one can help me I shall be very thankful to you. I don't know to create services for that and how to bind with data table.
Solved! Go to Solution.
HI @SG_10718850,
Kindly find the below attached links for your queries.
Datatable Creation: https://community.ptc.com/t5/IoT-Tips/ThingWorx-Tutorials-Introduction-to-DataTables/ta-p/821349
Retrieve data with a certain condition: https://www.ptc.com/en/support/article/CS346488
Datatable Available Services : https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Composer/DataStorage/DataTables/DataTableServices.html
Aggregate Snippet for Count/Sum the values based on columns : https://community.ptc.com/t5/ThingWorx-Developers/Infotable-Aggregate-on-multiple-columns/td-p/672040
I hope these links will helpful to you.
Thank & Regards,
Arun C
HI @SG_10718850,
Kindly find the below attached links for your queries.
Datatable Creation: https://community.ptc.com/t5/IoT-Tips/ThingWorx-Tutorials-Introduction-to-DataTables/ta-p/821349
Retrieve data with a certain condition: https://www.ptc.com/en/support/article/CS346488
Datatable Available Services : https://support.ptc.com/help/thingworx/platform/r9/en/index.html#page/ThingWorx/Help/Composer/DataStorage/DataTables/DataTableServices.html
Aggregate Snippet for Count/Sum the values based on columns : https://community.ptc.com/t5/ThingWorx-Developers/Infotable-Aggregate-on-multiple-columns/td-p/672040
I hope these links will helpful to you.
Thank & Regards,
Arun C