Skip to main content
5-Regular Member
June 6, 2017
Solved

How to joined query two data table?

  • June 6, 2017
  • 2 replies
  • 5349 views

Hi,

     is it possible to query two Data Table with joined field in thingworx? just like what we do in relational database sql. Thanks!

Best answer by CarlesColl

I've never did, but you shouldn't have any problem to have two JDBC connections to the same Database from different servers.

2 replies

1-Visitor
June 6, 2017

Search for Intersect Snippet

5-Regular Member
June 6, 2017

Hi Feng Zhang​,

Basically; we read the DataTable in two Infotables and apply InfoTable functions. You have option to apply Intersect (suggested by Carles) or Union (If the Datashape of both DataTables is same) as per your requirement.

fzhong5-Regular MemberAuthor
5-Regular Member
June 7, 2017

Carles ​&  Ankit Gupta

     Thank you for answer, but if these are two big Data Table,  will it be performance issue to read all data into Infotables?

5-Regular Member
June 7, 2017

Hi Feng Zhang​,

Yes, there could be performance issues when reading very large amount of data to infotables. It will vary based on the system configuration and network connectivity etc.