Data Table and Services - want to create a data table in which I want keep record of orders.

[SG_10718850]

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.

[Arun_C · Accepted 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