Join for two different database tables Windchill and Postgresql in Thingworx

[vcavic]

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

[zyuan1 · Accepted solution]

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.

[vcavic]

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

[zyuan1]

It's internal training and not accessible.

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

[zyuan1]

And also the filters,  it has leftJoin, right join, between, etc.

[slangley]

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