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

How to joined query two data table?

SOLVED
Regular Member

How to joined query two data table?

Hi,

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

Tags (1)
1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to joined query two data table?

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

View solution in original post

8 REPLIES 8

Re: How to joined query two data table?

Search for Intersect Snippet

Highlighted

Re: How to joined query two data table?

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.

Re: How to joined query two data table?

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?

Re: How to joined query two data table?

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.

Re: How to joined query two data table?

So I think I should seek for alternate solution because some of my Data Tables has more than 1 million rows.

Re: How to joined query two data table?

The DataTable it's a standard TW DataTable? if that's the case you are out of luck, you shouldn't use TW DataTables bigger than few hundred and thousand rows, you should go for an external storage database for this kind of DataTables and use embedded SQL support ( JDBC ) that provides TW.

Re: How to joined query two data table?

Thank you Carles, is there any limitation to store data in external storage database? For example,  can we share  things stored  externally between federation instances?

Re: How to joined query two data table?

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

View solution in original post

Announcements

Thingworx Navigate content has a new home! Click here to access the new Thingworx Navigate forum! ______________________________