Skip to main content
VaibhavShinde16-Pearl
16-Pearl
December 19, 2019
Solved

how can i generate database report in thingworx?

Hi ,

I am looking to generate database report(multiple database). can you explain here in few lines?

 

Thanks

slangleyAnswer
Support
January 10, 2020

Hi @VaibhavShinde.

 

Please refer to this page from our ThingWorx Help Center and follow the examples provided.

 

Regards.

 

--Sharon

View in thread

10 replies

posipova20-Turquoise
20-Turquoise
December 19, 2019

Could you please elaborate on the use case here and your requirements?

 

Translate
VaibhavShinde16-PearlAuthor
16-Pearl
December 20, 2019

I want to generate report in Grid format by retrieving data from database table , and i need to filter by using one of the column name with export button which will export data to excel.

How we can create it?

 

Thanks

Translate
posipova20-Turquoise
20-Turquoise
December 20, 2019

Is your database already connected to ThingWorx? You can connect any relational database via jdbc driver.

You would then write a sql command/query in a service to retrieve data. In the mashup, you can then use the advanced grid, a filter widget, and your query service bound to the filter and the grid to filter and sort data.

 

http://support.ptc.com/help/thingworx_hc/thingworx_8_hc/en/#page/ThingWorx%2FHelp%2FMashup_Builder%2FWidgets%2FAdvancedGrids.html

Translate
Terms & ConditionsAccessibility statement