Skip to main content
Apr 1, 2021 1:31 PM UTC
Solved

Join for two different database tables Windchill and Postgresql in Thingworx

Hi,

is it possible that we  merge  two different database tables Windchill and Postgresql  with same key ID and display in Thingworx Mashup Grid Advanced?

 

BR

Vladimir

zyuan1Answer
Apr 2, 2021 7:00 AM UTC

Sure, we have join service in snippet, and if you can get infotable result from TWX and windchill, surely you can get a joined result.

5 replies

zyuan1Answer
Apr 2, 2021 7:00 AM UTC

Sure, we have join service in snippet, and if you can get infotable result from TWX and windchill, surely you can get a joined result.

vcavicAuthor
Apr 6, 2021 7:51 AM UTC

@zyuan1 Any Tutorial? I can get infotable result from TWX(Database ThingTemplate) and windchill(oDataConnector). 

Apr 8, 2021 2:37 AM UTC

It's internal training and not accessible.

 

But you can start by testing the APIs in Resource: infoTableFunctions 

Apr 19, 2021 7:31 PM UTC

Hi @vcavic

 

If you feel your question has been answered, please make the appropriate response as the Accepted Solution for he benefit of others with the same question.

 

Regards.

 

--Sharon