how can i generate database report in thingworx?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
-
Best Practices
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @VaibhavShinde.
Please refer to this page from our ThingWorx Help Center and follow the examples provided.
Regards.
--Sharon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Could you please elaborate on the use case here and your requirements?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
yes I have connected the Database but I am unable to filter the data in Adv grid using data filter widget, I have nothing in service , just retrieving data and Infotable as output. I am sharing screenshot plz see it .hope u would reply with best solution.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Could you help me please. I have shared you the screenshots.
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You would need to enable sorting on the grid as well as a couple of other things for binding, mentioned in this article:
https://www.ptc.com/en/support/article?n=CS282617
I'm also attaching sample entities for the advanced grid. Please run the InitTable services on the Thing first to prepopulate the tables.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @VaibhavShinde.
If the response provided by @posipova answered your question, please mark it as the Accepted Solution for the benefit of others with the same question.
Regards.
--Sharon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Slangley,
i have done half of the part that is i retrieved data in grid but i am unable to filter it with advanced filter widget.
could you please help me out, i have simple one line code in service that is sql query for data retrieval and i am binding it to grid in mashup section but how to bind it to Filter widget ? , even i can see my columns in filter widget but after filtering grid is not refreshing,
Thank you
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @VaibhavShinde.
Please refer to this page from our ThingWorx Help Center and follow the examples provided.
Regards.
--Sharon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @VaibhavShinde.
Please let us know if you have resolved your issue. If so, please mark the appropriate response as the Accepted Solution for the benefit of others with the same question.
Regards.
--Sharon
