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

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

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

SG_10718850
5-Regular Member

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

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Arun_C
15-Moonstone
(To:SG_10718850)

HI @SG_10718850,

 

Kindly find the below attached links for your queries.

 

Datatable Creationhttps://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 Serviceshttps://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

 

 

View solution in original post

1 REPLY 1
Arun_C
15-Moonstone
(To:SG_10718850)

HI @SG_10718850,

 

Kindly find the below attached links for your queries.

 

Datatable Creationhttps://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 Serviceshttps://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

 

 

Top Tags